X-axis labels -- text "jan" "feb", comes out "1" "2" etc....
 

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

--
Message posted via http://www.officekb.com

Take a look at the series data for that series. I'm guessing you don't have
anything listed for Category (X) axis labels.

"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

--
Message posted via http://www.officekb.com

No the x series is defined as jan feb....

--
Message posted via http://www.officekb.com

What EXACTLY do you have listed for the Category X axis. You should see
something like:

=Sheet1!$A$1:$A$3

for example.

"jeremy via OfficeKB.com" wrote:

No the x series is defined as jan feb....

--
Message posted via http://www.officekb.com

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