problem with stacking charts.

  • Thread starter Thread starter libertyforall
  • Start date Start date
L

libertyforall

I am having a new problem of stacking line graphs in a single
figure using data from a pivot table in excel. I was able to do it
initially then for some reason when I started a new data sheet, the
figure shows a line graph of the second series as double the actual
value. If I do a figure with two charts, the line graph will show the
correct data in the first column but double the data for the second
column. If I take out the data of either column, it will appear
correct, even the second one. Any ideas on why this is happening and
how to fix it?
 
        I am having a new problem of stacking line graphs in a single
figure using data from a pivot table in excel. I was able to do it
initially then for some reason when I started a new data sheet, the
figure shows a line graph of the second series as double the actual
value. If I do a figure with two charts, the line graph will show the
correct  data in the first column but double the data for the second
column. If I take out the data of either column, it will appear
correct, even the second one. Any ideas on why this is happening and
how to fix it?
Click to expand...

Any advise on how to display a chart with two different sets of data?
I am using a pivot table then click copy and select two columns of
data to be graphed. It gives be two graphs but the second is incorrect.
 
Back
Top