How to label axis in excel? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

How to label axis in excel?

davidhurn Avatar
banned7y, 8m agoPosted 7 years, 8 months ago
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.

davidhurn Avatar
banned7y, 8m agoPosted 7 years, 8 months ago

All Comments

(10) Jump to unreadPost a comment
1 Like #2
Just right click on the chart and choose 'Chart options' you should be able to do everything in there
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
1 Like #5
I just checked for you, after you select the chart tools tabs, the options for adding titles are in the layout section.
I still can't change the x axis from 11-11 to 1997-2007... I'm useless.
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
1 Like #9
to add labels to both axis is quite long to tell :)
Thanks for the replies. Rep all round!

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!