Omiting data from Pivot Charts but displaying in Pivot Table

**Maudise** · 09-15-2011, 11:27 AM

Hi all,

I am working with some pivot tables and need to show the data within the pivot table in graphical format, my problem is that my tables contain more information than I want on my chart.

I have attached a file with a mock up of the sort of information I am wanting to show, in essence I am showing three different values: Volume of sales of a product; Value of these sales; proportion of sales which are to each product. Ideally I would like to show the first two on a single line chart (different axis to allow easier comparison) with the third column being a pie chart.

Can excel handle omitting data from a pivot chart which is contained within a pivot table and can you also have multiple charts off the same pivot table?

Thanks
Maudise

**Maudise** · 09-16-2011, 04:14 AM

bump, if it isn't possible could someone please say as I don't want to waste time searching for an answer which doesn't exist!

Maudise

**Maudise** · 09-20-2011, 04:17 AM

Bump

does anyone know if this is even possible?

**Andy Pope** · 09-20-2011, 05:02 AM

It's possible to do it with 1 pivot table and 2 pivot charts. The problem is that the contents of both charts will be all the items in the pivot table.
So to get around those issues you would need to move the pie chart information to the 1st column, as pie chart will only show 1 series the other 2 will not be used.

In the line chart you can format the line to have no line style, although it will still be in the legend.

Alternatively you can create a second pivot table using the same pivot cache and build a chart of that.