how to add axis labels in excel

• ITS home
• Help
• Services
• My IT account
• Security
• About

• Back to previous menu
• Help
• • How to ...
  • Frequently asked questions
  • FAQ list
  • How to (full list)
  • Getting help from IT Services
  • Guide
  • Report or request
  • Contact ITS
  • Security
  • Identifying and dealing with phishing emails

Questions and answers

264

How can I make an Excel chart refer to column or row headings?

---

Excel 2013 and Excel 2016

Arrange your data so that headings are directly above and to the left of the data to be charted. There should be no blank rows or columns. Make sure that you select the headings as well as the data before you create your chart.

If you have already created your chart:

1. Click on the chart to select it.
2. Click the Chart Filters button.
3. Click Select Data... at the bottom right of the dialog.
4. In the Select Data Source dialog box under Horizontal (Category) Axis Labels, clickEdit.
5. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, clickOK.
6. In the dialog box under Legend Entry Series, select the first series and clickEdit
7. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, clickOK.
8. Repeat for each series of data.
9. ClickOK.

Excel 2010

Arrange your data so that headings are directly above and to the left of the data to be charted. No blank rows or columns. Make sure that you select the headings as well as the data before you create your chart.

If you have already created your chart:

1. Click on the chart to select it.
2. From the Chart Tools, Layout tab, Current Selection group, select the Horizontal (Category) Axis
3. From the Design tab, Data group, select Select Data.
4. In the dialog box under Horizontal (Category) Axis Labels, click Edit.
5. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK.
6. Click OK.
7. Make sure that the chart is still selected.
8. From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis.
9. From the Design tab, Data group, select Select Data.
10. In the dialog box under Legend Entry Series, select the first series and click Edit
11. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK.
12. Repeat for each series.
13. Click OK.

Help us to improve this answer

Please suggest an improvement
(login needed, link opens in new window)

Your views are welcome and will help other readers of this page.

Categories

This is question number 264, which appears in the following categories:

• Software > Excel

how to add axis labels in excel

Source: https://www.sussex.ac.uk/its/help/faq?faqid=264

Posted by: whitebrociall.blogspot.com

Share this post