View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Nate Nate is offline
external usenet poster
 
Posts: 79
Default Pivot Chart Graphing Wrong Data

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