Question

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

Hint:

Select two consecutive columns, choose Pie, then use the Design and Format tabs for layout, style, bevel and rotation.

Answer 1

Step 1: Prepare the data:
A pie chart shows each item as a slice of the whole.
Enter the data on the worksheet. Select two consecutive columns only, the labels and their values.
Then select the chart type Pie from the ribbon.

Step 2: Choose the pie type:
Under Pie types, select the 3-D Pie option.
Click the plot of the pie chart. This displays Chart Tools with the Design, Layout and Format tabs.

Step 3: Set the layout and style:
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 you want.

Step 4: Add the bevel effect:
On the Format tab, in the Shape Styles group, click Shape Effects.
Then click Bevel.

Step 5: Set the 3-D options:
Click 3-D Options. Under Bevel, click the top and bottom bevel options and choose the type and the point size.
Under Surface, click Material and then click the material option you want.

Step 6: Close and rotate:
Click Close.
To rotate the chart for a better view, select the plot area.
Then, on the Format tab in the Current Selection group, click Format Selection.

Final Answer:
A pie chart is created in six steps: enter and select the data, choose the 3-D pie, set the layout and style, add the bevel, set the 3-D options, and rotate the plot area.