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!


--
koche005

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