How to label axis in excel?

    I want the years 1997-2007 along the x axis and the grams of fruit up the side.

    As you can see on the x axis is 1-11, how do I change this? In addition, how do I add a title and labels to both the x and y axis.

    Rep to all helpers.



    Original Poster Banned

    Just right click on the chart and choose 'Chart options' you should be able to do everything in there

    Original Poster Banned

    Btw I'm talking about the red column graph down the centre.

    Select chart tools at the top, and then you will have options to add axis labels etc

    I just checked for you, after you select the chart tools tabs, the options for adding titles are in the layout section.

    Original Poster Banned

    I still can't change the x axis from 11-11 to 1997-2007... I'm useless.

    Original Poster Banned

    to change 1 - 11 to 1997 -2007:

    Right click on the chart
    Click "Select Data"
    Point the "CATEGORY axis value" to the coloumn/cells containing the year value (i.e. 1997 - 2007) - you need this coloumn, if you dont have it yet, make one

    to add labels to both axis is quite long to tell

    Original Poster Banned

    Thanks for the replies. Rep all round!
    Post a comment
      Top Discussions
      1. What do you feel like whinging about today?1927341
      2. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7767213
      3. love affairs45
      4. What's you favourite 60s 70s 80s song ?983130

      See more discussions