Following are the steps related to preparation of charts, arrange the…

The correct answer is option 4- (D), (B), (C), (A).

(D) Enter data on a worksheet with proper column and row titles.

(B) Create a basic chart using the pattern from the panel available on top of the worksheet in Chart groups' option.

(C) Change the layout or style of chart

(A) Save a chart.

 

Following are the steps prepare a chart:

Step – 1: Enter data in a worksheet with proper column and row titles. (D)

Step – 2: Create a basic chart using the pattern from the panel available on top of worksheet in Chart groups’ option. (B)

Step – 3: Change the layout or style of chart.  (C)
               Apply a predefined chart layout.
               Apply a predefined chart style.
               Change the layout of chart elements.
               Change the format of chart elements.

Step – 4: Add or remove titles or data labels.
               Add (Remove) a chart title.
               Add (Remove) axis titles.
               Link a title to a worksheet cell.
               Add (Remove) data labels.

Step – 5: Show or hide a legend.

Step – 6: Display or hide chart axes or gridlines.
               Display (hide) primary axes
               Display (hide) secondary axes
               Display (hide) gridlines

Step – 7: Move (resize) a chart

Step – 8: Save a chart. (A)