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 Chart>Chart 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