To create a chart in Excel, the sequence to be followed is:

A. Add sub chart/graph (if needed)
B. Totalling of rows and columns
C. Selection of chart type from ribbon
D. Enter the data
E. Formatting of chart

Choose the correct answer from the options given below:

D, B, C, A, E

The correct answer is Option (2) - D, B, C, A, E.

Following are the steps prepare a chart:

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

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

Step – 3: Change the layout or style of chart.
               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