X-axis scaling problem

[jilli]

I am having problems with creating scatter plots in the new excel. In the
old one (2003), one could highlight a whole column, have the column headings
end up as the axes titles, and have blank data points ignored. The new one
changes the x-axis to other numbers if blank data or text is included in the
selection. For instance, I graphed data containing x-values from 1000 to
5000, and when the header column was included, Excel renumbered all the
x-values from 1 to 15, maybe by ranking them, but the system was unclear.
Short of sorting my data to remove blank data points and MANUALLY ENTERING
THE AXIS TITLES EVERY SINGLE TIME, how should I solve this problem?

 

[Jon Peltier]

Someone else also remembered Excel using column headers for X and Y axis
titles, but this is a feature that has never existed in Excel.

If you have blank or non-numeric data in the X value range for an XY chart,
Excel has always thrown a fit, not just in 2007. More selective memory?

You should always make sure your data is clean before making a chart. As for
using column headers for the axis titles, you might check out a little VBA
procedure I posted the other day on my new blog:

http://peltiertech.com/WordPress/2008/03/06/quick-vba-routine-xy-chart-with-axis-titles/

- Jon