Accountancy Part CGraphs and Charts for Business Data

To create a chart in Excel, the sequence to be followed is: A. Add su…

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

(D) Enter the data – the data are entered in a worksheet with row and column titles.

(B) Totalling of rows and columns – row and column totals are worked out in the worksheet.

(C) Selection of chart type from ribbon – the chart is created by choosing its type from the Insert tab.

(A) Add sub chart/graph (if needed) – sub-types or a combination chart are added to the basic chart.

(E) Formatting of chart – finally the layout, style and format of the chart elements are changed.

NCERT (2026-27 edition):
Following are the steps prepare a chart

Extract from the NCERT textbook

NCERT (2026-27 edition):
Step - 1 – “… The row totals (row number 11) gives the quarter wise total sales of products and the column totals (column number G) gives product wise total sales.”

NCERT (2026-27 edition):
Basics Steps for Graphs/Charts/Diagrams using Excel – “… We can also create a combination of chart by using more than one chart type in any chart.”