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?

X-axis scaling 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/200...h-axis-titles/

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


"jilli" wrote in message
...
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?