“PivotChart” from an existing “PivotTable”

We can make a chart from our “PivotTable” and it is called “Pivot Chart”.

Select the “PivotTable”.

Choose the “Options” tab from the “PivotTable Tools”.

And click the “PivotChart” button.

This opens the “Insert Chart” dialog, where we choose a chart.
Click the “Set as default chart” button if you want this chart as the default setting.
Click OK.
The “PivotChart” is placed in the same worksheet where our “PivotTable” is present.

On the right side of our window we have “Pivot table field list”, from which we can filter the different Axis Labels and Legend Fields.
The Axis Labels consist of various Row fields.
And the Legend fields consist of the various column fields.
It also displays the fields that have been placed in the Value Field.

The filter and sorting options are available to us in this pane and these are exactly the same as those we have in the PivotTable report.

When you are done working on your “PivotChart”, you might want to turn the panel to filter or sort.

Build PivotChart and PivotTable

Select a range of products from our “PivotTable”. Choose the “Insert” tab in the “Ribbon”.
Click the downward pointing arrow under “PivotTable”.
Select “PivotChart” from the drop-down menu.

If you wish to place it in a new worksheet ,choose a new worksheet in th dialog and click OK.This opens the PivotTable worksheet.

On the left side we still have the PivotTable field.
And the far right we still find our “PivotTable Field list”.
Link the fields from our field list to the list panel.

Place the fields from the field list in the areas that you want.
Whether you create a “PivotChart” from an existing “PivotTable”, or you can make these two together, it does not matter.

All the options for a regular chart are found for a “Pivot chart”.
The only difference is that here they are called “Pivot Chart Tools”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats