Question

State the steps to create a 'Pie Chart' using Excel.

Accepted Answer

Steps to create a pie chart. 1. Enter data on worksheet, select from to consecutive columns only and then select the chart type pie from the ribbon. (1) 2. Under Pie types select 3-D pie options click the plot of pie chart this displays the chart tools adding the design, layout and format and format tabs. (1) 3. On the design tab, in the chart layout group, select the layout to use. On the design tab in the chart styles group click the chart style. (1) 4. On the format tab in the shape styles group click shape effects and then click bevel. (1) 5. Click 3-D options and then under Bevel, click the top and bottom bevel options type and point size. Under surface, click material and then click the material options. (1) 6. Click close and to rotate chart for better perspective, select the plot area and then on the format tab in the current selection group click format selection. (1)

State the steps to create a 'Pie Chart' using Excel.

Marking-scheme solution

More from Graphs and Charts for Business Data