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
It's a line chart, and the horizontal data are categories (1, 2, 3, ...)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Thanks,
Very obvious now.
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
Also, what he said
As CC says, it's the "a" in your x values that is causing the xy-scatter to default to an x axis which is 1 to n. Where n is the number of points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks