Pivot Chart Graphing Wrong Data

N

Nate

Hi,

I'm using Excel 2007 and I have a Pivot Table that represents Revenue A,
Revenue B, and Grand Total Revenue (sum of A/B) for each of our sales reps.
However, the pivot chart to graph these (simple line graph) is not
functioning correctly. Revenue A is fine, but Grand Total is graphed
correctly but is labeled Revenue B, and the actual Revenue B is not in the
chart at all. Is this a bug in 07? Can someone please advise?

Thanks in advance.
Nate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculated Fields 1
Editing a column chart for Variance Walk negative numbers 3
how to make grand total to show up on pivotchart? 0
How to include the Grand Total Column in a pivot table chart? 1
Excel 2007 charts: want to avoid zero values 1
Divide by Zero Error in Pivot Table 2
Pivot Table Calculated Field using Grand Total 3
Pivot chart: wrong date order on horizontal axis 1

Top