I am trying to make a simple scatter plot. There are two columns of data. Excel will not plot values on the x- axis, only categories. I have entered the ranges for x and y values correctly, and the chart wizard shows it; yet, the chart comes out with the x-axis showing only the points numbered in the order they are entered in the spreadsheet. Oddly enough, if only one y-value is included, it plots properly; the x-axis correctly shows the range of x-values entered, and the single data point shows up at its proper xy location. as soon as I expand the y-range to more points, the x-axis reverts to categories, and can't be fixed. I think this is a bug. How so I fix it. Thanks.
Bookmarks