ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   X-axis labels -- text "jan" "feb", comes out "1" "2" etc.... (https://www.excelbanter.com/new-users-excel/29981-x-axis-labels-text-%22jan%22-%22feb%22-comes-out-%221%22-%222%22-etc.html)

jeremy via OfficeKB.com

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

Barb R.

I tried answering this before and it didn't come through. Let's see if it
works this time.

Take a look at the source data for the 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


jeremy via OfficeKB.com

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

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


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com