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.
Thanks Hans, that explains it. I was trying to figure out where it got those values from.