MS Excel - Pivot Charts

Advertisements


Pivot Charts

A pivot chart is a graphical representation of a data summary displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a pivot chart without a pivot table. All Excel charting features are available in a pivot chart

Pivot charts are available under Insert tab » PivotTable dropdown » PivotChart

Pivot Chart Example

Now let us see Pivot table with the help of example. Suppose you have huge data of voters and you want to see summarized view of the data of voter Information per party in the form of charts then you can use Pivot chart for it. Choose Insert tab » Pivot Chart to insert pivot table.

Pivot Chart Structure

MS Excel selects the data of the table.You can select the pivot chart location as existing sheet or new sheet. Pivot chart will depends on automatically created pivot table by the MS Excel. You can the the generated pivot chart in the below screen-shot

Pivot Chart Data

Advertisements
Advertisements