I'm having some trouble with a graph, I'm making a file to plot growth curves
for animals for a professor I work for, and the idea is that a client enters
body weight data and age and it plots it automatically.

I'm plotting Age (x-axis) vs. Body Weight (y-axis) on a scatter plot, body
weight is working out fine, but instead of plotting as the age (0.2 months, 7
months, etc.) the age is plotting in numerical order (1, 2, 3, 4, etc.). How
do I get it to plot as the actual number of months, and not just in order?

By the way, I'm using Excel 2007.

In the X (age) column, enter numbers, so 0.2 for 0.2 months, etc. Then make
an XY chart with the data. This treats the X values as numbers, not as
nun-numeric labels. You can format line and XY charts so the points look the
same (markers/no markers, lines/no lines).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"duarte1223" wrote in message
...
I'm having some trouble with a graph, I'm making a file to plot growth
curves
for animals for a professor I work for, and the idea is that a client
enters
body weight data and age and it plots it automatically.

I'm plotting Age (x-axis) vs. Body Weight (y-axis) on a scatter plot, body
weight is working out fine, but instead of plotting as the age (0.2
months, 7
months, etc.) the age is plotting in numerical order (1, 2, 3, 4, etc.).
How
do I get it to plot as the actual number of months, and not just in order?

Make sure that your X-axis data series has numerical values, not text.
--
David Biddulph

"duarte1223" wrote in message
...
I'm having some trouble with a graph, I'm making a file to plot growth
curves
for animals for a professor I work for, and the idea is that a client
enters
body weight data and age and it plots it automatically.

I'm plotting Age (x-axis) vs. Body Weight (y-axis) on a scatter plot, body
weight is working out fine, but instead of plotting as the age (0.2
months, 7
months, etc.) the age is plotting in numerical order (1, 2, 3, 4, etc.).
How
do I get it to plot as the actual number of months, and not just in order?