Question

State the steps in creating a pie chart using Excel.

Accepted Answer

Steps for creating a pie chart: (i) Enter the data in the worksheet and select the data from two (consecutive) columns only then select the chart type Pie from the ribbon. (ii) Under the Pie types select 3D Pie option then click the Plot area of Pie chart this displays the chart tools, adding the Design layout and format tabs. (iii) To the design tab select chart layout group and chart style group. (iv) On the format tab in the shape styles group click shape effects and then Bevel. (v) Click 3D option and then under Bevel click Top and Bottom Bevel options. (vi) In the Width and Height boxes for Top and Bottom Bevel options type the point size. (vii) Under the surface click Material and then click Material option. Then click close. (viii) On the format tab in the shape styles group & click shape effects and then click shadow. Under outer, inner or perspective click shadow option. (ix) To rotate the chart for a better perspective, select the plot area and then on the format tab in the current selection group click format selection. (x) Under Angle of first slice, drag the slider to the degree of rotation that you want then click close. again click chart area of the chart. (xi) On the format tab in the shape styles group click shape effects then click Bevel. (xii) Under Bevel select the option then select page layout click themes and use built into colour the presentation.

State the steps in creating a pie chart using Excel.

Marking-scheme solution

More from Graphs and Charts for Business Data