View Single Post
  #5   Report Post  
Jon Peltier
 
Posts: n/a
Default

Jeremy -

Did you actually create a line chart, or did you make a scatter chart? A
scatter chart will convert a list of nonnumerics into {1, 2, 3,...} for
the category axis.

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


jeremy via OfficeKB.com wrote:

I'm trying to set up a simpe line graph with months label on the x-
axis....but just i can't label the months , the labels come out "1" to
"12". Any help?

The source data are months, and I tried messing around with
the axis label but can't seem to change it...

Thanks.
Jeremy