How to Generate a Pivot Chart from a Pivot Table in Excel 2007

After creating a pivot table, you can create a pivot chart to display its summary values graphically in literally two really simple steps:

1) Click the Pivot Chart command button in the Tools group on the Options under the Pivot Table Tools Contextual tab to open the Create Chart dialog box.
Remember that the Pivot Table Tools contextual tab with its two tabs - Options and Design - automatically appears whenever you click any cell in an existing pivot table.

2) Click the thumbnail of the type of chart you want to create in the Create Chart dialog box and then click OK.

As soon you click OK after selecting the chart type, Excel displays three things in the same worksheet as the pivot table:

Pivot chart using the type of chart you selected that you can move and resize as needed (officially known as an embedded chart.

Pivot Chart Filter Pane containing three drop-down lists - Axis Fields (Categories), Legend Fields (Series), and Report Filter - along with a Values field at the very bottom listing the name of the field whose values are summarized in the chart

Pivot Chart Tools contextual tab divided into four tabs - Design, Layout, Format, and Analyze - each with its own set of buttons for customizing and refining the pivot chart

Tags: pivot chart,pivot table,worksheet,pivot

Related Articles