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.
Both since you have text (N/A) within numbers for X axis. If instead of the text you use =NA() which returns #N/A error and add to options
chart works correctly.
Thanks Sergei. Why does having the text there cause the numbers to display so strangely e.g. up to 250?