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:
Answer & explanation
Correct answer: option 2
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