simple chart wrong plotting

[TarsierSpectral]

I want to create simple chart in excel. This is the data I am using for it
1 2 3
-2 -3 -1
4 -5 5

when I create my chart 4 ends up being at 3 on the y-axis -2 ends up at -1 etc.
When I click on the point it says that 4 is 4 but when looking at y-axis it isn't

Only the first row 1 2 3 is plotted correctly why?????

 

[SkipVought]

Hi,

Do you have the Source Data Range option set to...

Series in ROWS?

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[TarsierSpectral]

yes rows

 

[TarsierSpectral]

I figured it out. It was the chart type. For some reason when you pick the line chart (the second one) it doens't do it right. If you pick the first line chart it looks the same and it has correct values.

thanks