Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Pivot Chart - Double Column


posted by GenDemo
Mon, Mar 10 2014

Downloads: 13
File size: 16.6kB
Views: 2,786
Pivot Chart - Double Column
Filed under: ,

In the file attached, I have constructed an example of the data i am working with.

The data table gets fed into a pivot table that splits the branches into two groups. Each have a volume, rate and benchmark.

However, when I plot the chart (as shown in the file) the benchmark shows up twice on the data table underneath the graph. I would like to get rid of one of these entries, i.e. just have one benchmark show in the data table underneath the graph.

Could anyone please help?

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.