Seemingly Bizarre chart behaviour (characters other than numbers in data)

**S.Tuck** · 11-09-2009, 11:44 AM

Hi,

Can anybody tell me what's happening here?
excelissue.jpg.jpg

Where is the data that is being used to plot the chart?! is this a bug?

Thanks in advance,
Yours slightly perplexed,

S.Tuck

**shg** · 11-09-2009, 11:48 AM

It's a line chart, and the horizontal data are categories (1, 2, 3, ...)

**S.Tuck** · 11-09-2009, 11:51 AM

Thanks,

Very obvious now.

**Cheeky Charlie** · 11-09-2009, 11:51 AM

The data appear to be on the page, but it's hard to say from a picture. Perhaps you could upload an example of the actual workbook? I would guess that the "a" in your data (B6) is forcing the xy chart to create an arbitrary interval between your points as it can not compare 4 and a on one axis - but this is a bit of a speculation without an Excel example.

HTH