While making charts and graphs in excel it is very important to label the axes so that the person who is reading them may know what the x and y axes represents in the chart. Few days back one of my readers asked me how to label axes in excel. Actually, the option to label the axes is not quiet visible on chart. So, today in this post I will be guiding you to label axes in excel both 2007 and 2010 versions.
Label Axes in Excel 2007 and 2010 :
If you are working on excel 2007 or 2010 then after creating the graph you have to navigate to the layout tab in the ribbon and from there you can add the labels to the axes. Step by Step Instructions are as below:
- First of all you have to create a chart, and then select the chart data. If you already have created a chart then there is no need of this step.
- Now navigate to the layout option on the top ribbon, and there select the option “Axis Titles” select the “Primary Horizontal Axis Title” and finally select the option “Title Below axis”
- Now a default title will be placed below your horizontal axis, you can rename it as you wish.
- Now for Vertical Axis title again navigate to “Axis Titles”> “Primary Vertical Axis Title” , now you can select any of the vertical title types.
- It will create a title box just before your vertical axis, and you can rename it.
Although the screenshots above are of Excel 2007 but the same is also applicable to Excel 2010. If you are facing some problems then you can refer the video tutorial below to label axes in excel. This video tutorial explains the process quiet simply.
Drop in your feedback or queries in the comments section below.