Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 12, 07:17 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2012
Posts: 1
Default Excel line chart not displaying correctly

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

I have data pulled into a stacked line chart. The lines should all show 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 in value but the line goes up. I have no idea how to fix this.....
Attached Images
 

  #2   Report Post  
Old November 27th 12, 05:42 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by eshort View Post
I'm not even sure how to search this issue... All attempts have come up empty...

I have data pulled into a stacked line chart. The lines should all show 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 in 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 data points are plotted cumulatively.

Take October 2012 for example. The purple is 5% and the blue is 2% so 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%. Make sense?

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XY charts not displaying correctly in Excel 2007 RodW Charts and Charting in Excel 1 September 8th 09 12:41 PM
Excel Web Query not displaying Umlaut correctly [email protected] Excel Programming 0 June 23rd 06 03:55 PM
Excel does not displaying formatting correctly Cookie Excel Discussion (Misc queries) 2 April 24th 06 02:55 PM
Displaying data in bar form on a line chart expo Charts and Charting in Excel 1 March 2nd 06 12:10 AM
chart displaying horizontal line for zero data [email protected] New Users to Excel 3 February 1st 05 09:22 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017