problem with stacking charts.


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?
 
Ad

Advertisements

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?

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.
 

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

Top