A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

line chart displays wrong values



 
 
Thread Tools Display Modes
  #1  
Old February 26th, 2005, 05:23 PM
koche005 koche005 is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2005
Posts: 1
Default line chart displays wrong values

Yesterday my chart wizard went crazy
A simple chart, I've done them thousands of times
Now when I select 2 series and try to plot a 2 line chart the first series plots fine and the second plots as the sum of the two series.

I tried shutting down, restarting, typing the data manually into a new sheet, sending the data to a colleague -- the result is the same

HELP!
  #2  
Old February 26th, 2005, 09:43 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

It sounds like you created a stacked line chart. To change it:

Select the chart
Choose ChartChart Type
Select the Line chart type
Select the Line chart sub-type (at the top left)
Click OK

koche005 wrote:
Yesterday my chart wizard went crazy
A simple chart, I've done them thousands of times
Now when I select 2 series and try to plot a 2 line chart the first
series plots fine and the second plots as the sum of the two series.

I tried shutting down, restarting, typing the data manually into a new
sheet, sending the data to a colleague -- the result is the same

HELP!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart X axis values are wrong! Sorin Setting Up & Running Reports 0 December 17th, 2004 10:05 PM
cumulative line chart problems neowok Charts and Charting 3 June 22nd, 2004 02:52 AM
Discontinue part of line in chart Jon Peltier Charts and Charting 0 April 1st, 2004 10:27 PM
Plotting a datapoint on an existing Line chart Tushar Mehta Charts and Charting 0 November 23rd, 2003 01:08 AM
How to create stacked line chart with some empty value? Jon Peltier Charts and Charting 0 November 12th, 2003 06:35 PM


All times are GMT +1. The time now is 08:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.