Forum Discussion
Solved
Strange Behaviour With XY Graph and Text
Hi folks, I'm trying to understand the behaviour of an XY scatter graph. Spreadsheet at the following link https://www.dropbox.com/s/1otozhfjqmwkpz4/Book2.xlsx?dl=0 I want to plot two column...
The x-values of an XY Scatter chart should not be text. Cell B191 contains the text value N/A. This causes Excel to use sequential numbers 1 ... 227 for the x-axis.
If you either change B191 to the error value #N/A or clear this cell, the chart will look the way you want.
The x-values of an XY Scatter chart should not be text. Cell B191 contains the text value N/A. This causes Excel to use sequential numbers 1 ... 227 for the x-axis.
If you either change B191 to the error value #N/A or clear this cell, the chart will look the way you want.
- Actually, text in the Y value range will be plotted as zero. It's text within the X values which change these X values from numerical values to simple counting numbers from 1 to the number of points.
Yes, that's what Sergei and I wrote.
Sorry, I didn't mean to step on your post. When I read it, I thought it said "the values of an XY Scatter chart".
- Thanks Hans, that explains it. I was trying to figure out where it got those values from.
