Using Pivot Charts For Better Analysis

Image showing a pivot chart displaying the same info as two separate charts

Using Pivot Charts when analyzing data can show you more in one image and quicker than standard charts where you may have to create multiple charts.

In this image, there are two standard charts showing the sales by person and the sales by region.

But to the right we have a Pivot Chart which shows the sales by person and region in one chart.

Image showing a pivot chart displaying the same info as two separate charts


Creating Pivot Charts is easy once you understand Pivot Tables (click here to read about Pivot Tables).

I have created a table based on a table of information below.

Image of basic pivot table

Click on the Pivot Table and you will see PivotTable Tools options.

Towards the right-hand side of the Analyze menu, there is a “PivotChart” button.

Image of ribbon containing pivot chart command

Press the button and select the chart type you want, I am using a standard clustered column chart.

This creates a chart based on the pivot table.

As you can see, the sales in each region are broken down by person.

You can also apply filters to the Region and Names displayed by using the grey buttons.

Image of our Pivot Chart

Changing the layout of the information displayed is the same as changing the layout of a Pivot Table……. simple as that!!

You can play around with the layouts, chart type, filters and the other format options of the table.

With a bit of practice you can quickly and easily create informative charts in no time.

Click Here to Leave a Comment Below 0 comments

Get every new post delivered to your Inbox

Join other followers:

%d bloggers like this: