Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing an axis label (Excel 2003 SP2)

    I'm assisting a friend with a chart he created. He's trying to change the axis label from 1-12 to Jan-Dec on the line chart in the workbook attached. I can't figure out how and where it's pulling those labels so I can change them. Thanks....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing an axis label (Excel 2003 SP2)

    It's easiest to enter the month names Jan - Dec in A45:A56 (enter Jan in A45, and fill down to A56).
    Then activate the chart, and select Chart | Source Data.
    Click in the Series tab, and specify ='Attendance Statistics 2004'!$A$45:$A$56 in the Category axis labels box.

    See attached modified workbook.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing an axis label (Excel 2003 SP2)

    So how did you do the bar charts that had three columns for one month?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing an axis label (Excel 2003 SP2)

    Their series are based on disjunct cells, e.g.

    =('Attendance Statistics 2004'!$B$37,'Attendance Statistics 2004'!$E$37,'Attendance Statistics 2004'!$H$37,'Attendance Statistics 2004'!$K$37,'Attendance Statistics 2004'!$N$37,'Attendance Statistics 2004'!$Q$37)

    So I set the Category axis labels to disjunct cells:

    ='Attendance Statistics 2004'!$C$3,'Attendance Statistics 2004'!$F$3,'Attendance Statistics 2004'!$I$3,'Attendance Statistics 2004'!$L$3,'Attendance Statistics 2004'!$O$3,'Attendance Statistics 2004'!$R$3

    As in the other chart, you can see this by activating the chart, then selecting Chart | Source Data and activating the Series tab.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •