Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Linking Axis Labels | Charts and Charting in Excel |