Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2007 - Axis Scaling Dialog problem | Charts and Charting in Excel | |||
Scaling x-axis with time | Charts and Charting in Excel | |||
X-Axis scaling on graph | Charts and Charting in Excel | |||
2 Axis chart and scaling | Charts and Charting in Excel | |||
Varying axis scaling | Charts and Charting in Excel |