-1
1
I have an excel scatter plot with 5 different data series on single chart. First 4 series are working well. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9 .. ) the plot is displayed with x-axis values as 1,2,3 but not as the data specified. Changing the chart types did not help. Not sure how can I get the x-axis as data but not as sequential numbers. Any help is appreciated. Thanks.
Added the screenshot of chart and its xaxis data. The values are in number format only just as data for other series. Everytime I am adding a new series on to this, its starting with one number later.... (1,2,3...) next series x axis at (2,3,4....) but not with real x values as selected.
We would need to see what the data looks like, how you're defining the series, and what the output looks like. Without that, it's hard to even guess. Please edit the question to include the detail. – fixer1234 – 2018-05-31T05:57:55.967
It sounds like Excel is trying to treat your new x-axis series as categorical, which is likely from a bad (i.e. non-numeric) value, that cannot be plotted on a numeric (scatter plot) scale. I'd start by validating that all the values (in both axis of the new series) are actually numbers. – dav – 2018-05-31T11:52:48.950
Sorry for lack of details, I just added screen shot and more details. Please check and let me know. – santu – 2018-05-31T13:11:17.227
I could fix it... The problem is X-axis range is for 18 cells and all the cells had formula with IF condition... When I removed the IF condition, x-axis worked well as numbers – santu – 2018-05-31T15:09:57.263