X-axis scaling problem

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?

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/20...th-axis-titles/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jilli" <jilli@discussions.microsoft.com> wrote in message
news:8C059084-A68E-470C-8E11-03527C2F7CA3@microsoft.com...
>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?