When you create a chart in Excel 2007 or later, it isn’t obvious how to label the axes. Here we show you how it’s done by finding the settings within the Office Ribbon. See also: Office 2013 review

Excel is a marvellous and powerful spreadsheet tool. It’s pretty adept at creating charts from your data, but in Excel 2007, 2010 and 2013, it can be baffling how to add labels to the axes.

If you have Excel 2007 or 2010, the option is in the Layout tab, which should be highlighted when you click on the chart within your spreadsheet.

In the Ribbon toolbar, click Axis Titles, then choose either the horizontal or vertical axis and finally Title Below Axis. You can now enter an axis label and format it using Excel’s usual text options. (Click the image to enlarge)

Add axis labels Excel 2007 2010

If you have Excel 2013, the option has been moved again. Now if you click on a chart you’ll see some controls pop up to the right-hand side. Click on the green + symbol to add a chart element. Then you can tick the box for Axis Titles and they will appear for both the horizontal and vertical axes. Simply type your labels and format them to your liking. (Click the image to enlarge)

 Add axis labels Excel 2013