View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Problem with Graphs

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?