BUG?: Excel scatter chart: will not plot x-values

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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.
 
Bob,

Ensure that this is in fact an xy chart: With the chart selected, Chart -
Chart Type. If so, look at Chart - Source Data, Series tab: Ensure there
that the x and y cell references are what you want. Still failing? Remove
formatting from your x and y cells (Format - Cells - Number - General).
What do you see there?
 
Bob -

Two things to check:

(1) Be sure the chart type is XY (Scatter).

(2) Be sure all data values are numeric, not text. If even one is
non-numeric, the XY (Scatter) chart will revert to Line (category labels on
the horizontal axis).

To fix, enter 0 (zero) in a cell, copy the cell, select the cells containing
the chart data, and choose Edit | Paste Special | Add.

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++++
 
Forget all the checks. I have spent several hours with clean data, changing the range once the plot was drawn, rebooting etc, It is a "feature" of Excel 2003 and 2007. I found in Excel 2007 I could get about 9months of a single variable, hourly data, plotted as a scatter plot but any more the plot reverted to a line plot. It did accept date or number entries. Plotting 5 variables, the limit was about 5 weeks of data. I regret getting rid of my very old QPRO.
 
Back
Top