Excel line chart not displaying correctly


E

eshort

I'm not even sure how to search this issue... All attempts have come u
empty...

I have data pulled into a stacked line chart. The lines should all sho
trending numbers separately from each other (no overlap). As it stands
the data labels are correct but the placement on the chart is incorrect
See attached screenshot. Help???

The bottom (purple) line seems to be correct.
The rest are not plotting properly. You can see the numbers go down i
value but the line goes up. I have no idea how to fix this....

+-------------------------------------------------------------------
|Filename: 11-26-2012 1-04-49 PM.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=698
+-------------------------------------------------------------------
 
Ad

Advertisements

S

Spencer101

eshort;1607633 said:
I'm not even sure how to search this issue... All attempts have come u
empty...

I have data pulled into a stacked line chart. The lines should all sho
trending numbers separately from each other (no overlap). As it stands
the data labels are correct but the placement on the chart is incorrect
See attached screenshot. Help???

The bottom (purple) line seems to be correct.
The rest are not plotting properly. You can see the numbers go down i
value but the line goes up. I have no idea how to fix this.....


The chart looks fine to me. Because it's a stacked chart the dat
points are plotted cumulatively.

Take October 2012 for example. The purple is 5% and the blue is 2% s
the blue is effectively 2% added to the 5% so is plotted at the 7
point. The red is 25% on top of that 7% so is plotted at 32%. Mak
sense?

If this is not the result you're after then you need something othe
than a stacked chart

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

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