Arrange the following steps in order to create a pie chart in Excel
A. Select the data from two (consecutive) columns only.
B. Select the chart type Pie from the ribbon
C. Under Pie types, select one of the pie chart options.
D. Enter the data in a worksheet.
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → D, A, B, C
A pie chart is drawn from data already on the sheet, so the data must be entered first (D). Excel then needs to know which data to plot, and a pie shows one series as parts of a whole, so the data is selected from two consecutive columns (A): one for the labels, one for the values. Only with the data selected does choosing Pie on the ribbon (B) draw the chart, and the particular pie option (C) is picked from the list that this choice opens.
NCERT (2026-27 edition): |