Excel 2010 Pivot Chart Creation
How to Create and Format a Pivot Chart in Excel 2010 - For Dummies
Page 1 of 3
How to Create and Format a Pivot Chart in
Excel 2010
By Greg Harvey
7 of 9 in Series: The Essentials of Excel 2010 Pivot Tables and Pivot Charts
After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the chart types available with Excel when you create a pivot chart.
Create a pivot chart
Follow these steps to create a pivot chart based on an existing pivot table in a worksheet: 1. Create the pivot table and then click any cell in the pivot table on which you want to base the chart.
2. Click the PivotChart button in the Tools group of the PivotTable Tools
Options tab.
The Insert Chart dialog box appears.
You have many design choices for your pivot chart.
http://www.dummies.com/how-to/content/how-to-create-and-format-a-pivot-chart-in-excel-... 2/6/2012
How to Create and Format a Pivot Chart in Excel 2010 - For Dummies
Page 2 of 3
3. Click the thumbnail of the type of chart you want to create.
4. Click OK.
Excel displays the pivot chart in the worksheet.
To delete a pivot chart, select a chart boundary and press the Delete key.
Move a pivot chart to its own sheet
You may find it easier to customize and work with a pivot chart if you move the chart to its own chart sheet in the workbook. To do so, click the Move Chart button on the
PivotChart Tools Design tab, click the New Sheet button in the Move Chart dialog box, and then click OK.
A clustered column pivot chart moved to its own chart sheet.
Format a pivot chart
As soon you create a pivot chart, Excel displays these items in the worksheet:
• Pivot chart using the type of chart you selected that you can move and resize as needed (officially known as an embedded chart).
• PivotChart Tools contextual tab divided into four tabs — Design, Layout,
Format, and Analyze — each with its own set
Page 1 of 3
How to Create and Format a Pivot Chart in
Excel 2010
By Greg Harvey
7 of 9 in Series: The Essentials of Excel 2010 Pivot Tables and Pivot Charts
After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the chart types available with Excel when you create a pivot chart.
Create a pivot chart
Follow these steps to create a pivot chart based on an existing pivot table in a worksheet: 1. Create the pivot table and then click any cell in the pivot table on which you want to base the chart.
2. Click the PivotChart button in the Tools group of the PivotTable Tools
Options tab.
The Insert Chart dialog box appears.
You have many design choices for your pivot chart.
http://www.dummies.com/how-to/content/how-to-create-and-format-a-pivot-chart-in-excel-... 2/6/2012
How to Create and Format a Pivot Chart in Excel 2010 - For Dummies
Page 2 of 3
3. Click the thumbnail of the type of chart you want to create.
4. Click OK.
Excel displays the pivot chart in the worksheet.
To delete a pivot chart, select a chart boundary and press the Delete key.
Move a pivot chart to its own sheet
You may find it easier to customize and work with a pivot chart if you move the chart to its own chart sheet in the workbook. To do so, click the Move Chart button on the
PivotChart Tools Design tab, click the New Sheet button in the Move Chart dialog box, and then click OK.
A clustered column pivot chart moved to its own chart sheet.
Format a pivot chart
As soon you create a pivot chart, Excel displays these items in the worksheet:
• Pivot chart using the type of chart you selected that you can move and resize as needed (officially known as an embedded chart).
• PivotChart Tools contextual tab divided into four tabs — Design, Layout,
Format, and Analyze — each with its own set