Pivot Chart Trouble - This should be easy

  • Thread starter Thread starter CWK
  • Start date Start date
C

CWK

I've been having trouble with what should be a pretty simple thing. I
have a regular line chart with two data series, that I'd like to
replicate as a Pivot Chart to make it easier to update. (http://
ceneketcham.googlepages.com/oldchart.jpg)

I have a Pivot Table that has the information organized in a way that
makes sense (http://ceneketcham.googlepages.com/pivtable.jpg), but
when I create the chart, I only see one data series that looks
horrible (http://ceneketcham.googlepages.com/pivchart.jpg).

I've been messing around with this for a few hours now, and this is as
close as I can get. What am I doing wrong here? Thanks.
 
In the pivot table, drag the Data button onto the cell that contains the
word total. That should make the chart easier to read.
 
Back
Top