create a pie chart create pie chart, slide 1copyright © 2004, jim schwab, university of texas at...

Create a Pie Chart

Create Pie Chart, Slide 1 Copyright © 2004, Jim Schwab, University of Texas at Austin

A pie chart is useful for

The data for the pie chart


We will create a pie chart for the data in this small table that tells us we have 47 males and 82 females within the group.

We will create a pie chart for the data in this small table that tells us we have 47 males and 82 females within the group.

Opening the chart toolbar


First, to create the pie chart, select the data in the worksheet including the labels, cells A1 through B2.

First, to create the pie chart, select the data in the worksheet including the labels, cells A1 through B2.

Second, open the Chart toolbar from the View > Toolbars menu.

Second, open the Chart toolbar from the View > Toolbars menu.

Selecting the type of chart


First, on the Chart tool bar, click on the down arrow button for the Chart Type tool button.

First, on the Chart tool bar, click on the down arrow button for the Chart Type tool button.

Second, click on the icon for the 3-D Pie Chart.

Second, click on the icon for the 3-D Pie Chart.

The initial 3-D pie chart


When we clicked on the 3-D Pie Chart icon, Excel created a pie chart, using the data that was selected on the worksheet.

When we clicked on the 3-D Pie Chart icon, Excel created a pie chart, using the data that was selected on the worksheet.

Resizing the pie chart - 1


To enlarge the pie chart on the worksheet, position the mouse cursor over the upper left corner of the chart and hold down the left mouse button.

To enlarge the pie chart on the worksheet, position the mouse cursor over the upper left corner of the chart and hold down the left mouse button.



With the mouse cursor over the upper left corner of the chart, drag the mouse upward and to the left. The chart will be resized to match the dashed border.

With the mouse cursor over the upper left corner of the chart, drag the mouse upward and to the left. The chart will be resized to match the dashed border.



To further enlarge the pie chart on the worksheet, position the mouse cursor over the lower right corner of the chart and hold down the left mouse button.

To further enlarge the pie chart on the worksheet, position the mouse cursor over the lower right corner of the chart and hold down the left mouse button.



With the mouse cursor over the lower right corner of the chart, drag the mouse down and to the right.

With the mouse cursor over the lower right corner of the chart, drag the mouse down and to the right.

The chart will be resized to match the dashed border.

The chart will be resized to match the dashed border.

Positioning the legend - 1


By default, the legend for the pie slices is positioned on the right of the chart. We can reposition it using the Format Legend command.

By default, the legend for the pie slices is positioned on the right of the chart. We can reposition it using the Format Legend command.

Right click on the legend and select Format Legend from the popup menu.

Right click on the legend and select Format Legend from the popup menu.



On the Format Legend dialog, click on the Placement tab to view the optional positions for the legend.

On the Format Legend dialog, click on the Placement tab to view the optional positions for the legend.



To position the legend at the bottom of the chart, click on the Bottom option button.

To position the legend at the bottom of the chart, click on the Bottom option button.

After selecting the placement location, click on the OK button.

After selecting the placement location, click on the OK button.



The legend is now located at the bottom of the chart.

Note that the size of the pie element changed to reflect the space available for the chart.

The legend is now located at the bottom of the chart.

Note that the size of the pie element changed to reflect the space available for the chart.

Removing the legend from the chart - 1


To remove the legend completely from the chart, right click on the legend and select Clear from the popup menu.

To remove the legend completely from the chart, right click on the legend and select Clear from the popup menu.

Removing the legend from the chart - 2


The legend is now removed from the chart and the size of the pie element has again changed to reflect the space available for the chart.

The legend is now removed from the chart and the size of the pie element has again changed to reflect the space available for the chart.

Restoring the legend to the chart - 1


We can restore or add the legend to the chart as a chart option.

We can restore or add the legend to the chart as a chart option.

Right click on the chart area and select Chart Options from the popup menu.

Right click on the chart area and select Chart Options from the popup menu.



First, click on the Legend tab in the Chart Options dialog box.

First, click on the Legend tab in the Chart Options dialog box.

Second, click on the check box to mark Show Legend.

Second, click on the check box to mark Show Legend.

The legend appears in the preview of the chart.

The legend appears in the preview of the chart.

Third, click on the OK button to close the dialog box.




The legend again appears on the chart.

The legend again appears on the chart.

Labeling the slices of the pie - 1


We can provide the same information in the legend by labeling the slices of the pie.

We can provide the same information in the legend by labeling the slices of the pie.

First, clear the legend from the chart.

First, clear the legend from the chart.

Second, to add labels to the slices, right click on the chart and select Chart Options from the popup menu.

Second, to add labels to the slices, right click on the chart and select Chart Options from the popup menu.



First, in the Chart Options dialog, click on the Data Labels tab.

First, in the Chart Options dialog, click on the Data Labels tab.Second, mark

the check box for Category name to add Males and Females as labels.

Second, mark the check box for Category name to add Males and Females as labels.

Third, mark the check box for Percentage to add the percent of cases in each slice to the labels.

Third, mark the check box for Percentage to add the percent of cases in each slice to the labels.

Fourth, accept the default check box for Show leader lines to include connecting lines when the a label is far away from the slice.

Fourth, accept the default check box for Show leader lines to include connecting lines when the a label is far away from the slice.

Fifth, click on the OK button to close the dialog box.

Fifth, click on the OK button to close the dialog box.



The pie chart with category and percentage labels added.

The pie chart with category and percentage labels added.

Adding a title to the chart - 1


To add a title to the chart, right click on the chart and select Chart Options from the popup menu.

To add a title to the chart, right click on the chart and select Chart Options from the popup menu.



First, in the Chart Options dialog, click on the Titles tab.

First, in the Chart Options dialog, click on the Titles tab.

Second, click on the Chart title text box and type the text Gender Breakdown.

Second, click on the Chart title text box and type the text Gender Breakdown.





The pie chart with a title added.

The pie chart with a title added.

Changing the color of a slice - 1


To change the color of a slice, we must first select the slice. Selecting a slice requires that we click on the slice that we want to change twice.

To change the color of a slice, we must first select the slice. Selecting a slice requires that we click on the slice that we want to change twice.

Click on the pie chart element so that its selection handles appear.




Click a second time on the slice of the pie that we want to change.

The selection handles for the slice appear.

Click a second time on the slice of the pie that we want to change.




With the selection handles for the slice visible, right click on the slice and select the Format Data Point command from the popup menu.

With the selection handles for the slice visible, right click on the slice and select the Format Data Point command from the popup menu.



First, in the Format Data Point dialog, click on the Patterns tab.

First, in the Format Data Point dialog, click on the Patterns tab.

Second, click on the red color swatch to change the color of the slice to red.

Second, click on the red color swatch to change the color of the slice to red.





The pie chart with a different color slice.

The pie chart with a different color slice.

Exploding a slice - 1


To emphasize a particular slice, we can explode it or separate it from the other slices of the pie.

To emphasize a particular slice, we can explode it or separate it from the other slices of the pie.





Click a second time on the slice of the pie that we want to explode.


Click a second time on the slice of the pie that we want to explode.




Hold the mouse button down and drag the slice to the left.

The outline approximates the separation between the slices.

Hold the mouse button down and drag the slice to the left.

The outline approximates the separation between the slices.



The exploded slice of the pie further emphasizes the red slice.

The exploded slice of the pie further emphasizes the red slice.

Rotating the pie chart - 1


We can also rotate the pie chart so the red slice comes more to the front of the chart.

We can also rotate the pie chart so the red slice comes more to the front of the chart.

Right click on the chart area and select 3-D View from the popup menu.

Right click on the chart area and select 3-D View from the popup menu.



First, in the 3-D View dialog, click on the counter-clockwise rotation button until the Rotation text box contains 320.

The wire-frame sketch of the pie chart moves to show the effect of the changes.

First, in the 3-D View dialog, click on the counter-clockwise rotation button until the Rotation text box contains 320.

The wire-frame sketch of the pie chart moves to show the effect of the changes.

Second, click on the OK button to close the dialog box.

Second, click on the OK button to close the dialog box.

The Default button restores the original settings of the chart.

The Default button restores the original settings of the chart.



The chart with the rotated, exploded slice in the forefront of the pie chart.

The chart with the rotated, exploded slice in the forefront of the pie chart.

Resizing the plot area - 1


Excel continuously scales the drawing of the pie chart in response to changes that we make. If needed, we can manually enlarge the space occupied by the pie element.

Excel continuously scales the drawing of the pie chart in response to changes that we make. If needed, we can manually enlarge the space occupied by the pie element.

Select the plot area for the chart by clicking in a corner of the rectangle surrounding the pie element.

Select the plot area for the chart by clicking in a corner of the rectangle surrounding the pie element.



Position the cursor over the upper left resizing handle for the plot area, hold down the mouse button.

Position the cursor over the upper left resizing handle for the plot area, hold down the mouse button.



Holding down the mouse button, drag the mouse upward and to the left.

The pie element will be resized to the dashed rectangle.

Holding down the mouse button, drag the mouse upward and to the left.

The pie element will be resized to the dashed rectangle.



The pie element has been resized, but is no longer centered in the chart area.

The pie element has been resized, but is no longer centered in the chart area.

Again, select the plot area for the chart by clicking in a corner of the rectangle surrounding the pie element.

Again, select the plot area for the chart by clicking in a corner of the rectangle surrounding the pie element.



With the cursor still positioned in a corner of the rectangle surrounding the pie element, hold down the mouse button and drag the plot area to the right until the pie element is centered under the title.

With the cursor still positioned in a corner of the rectangle surrounding the pie element, hold down the mouse button and drag the plot area to the right until the pie element is centered under the title.

When the dashed rectangle around the pie element is centered under the title, release the mouse button.

When the dashed rectangle around the pie element is centered under the title, release the mouse button.



The pie chart is now centered under the title, and has an exploded, red slice showing the percentage of females in the gender breakdown.

The pie chart is now centered under the title, and has an exploded, red slice showing the percentage of females in the gender breakdown.

create a pie chart create pie chart, slide 1copyright © 2004, jim schwab, university of texas at...

Documents