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
>