print friendly version

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, 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. In the dialog box under Legend Entry Series, select the first series and click Edit
  7. 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.
  8. Repeat for each series of data.
  9. Click OK.

Excel 2013 Chart Filters Button

 

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:

Created by Jason Bailey on 27 July 2001 and last updated by Paul Ryan on 25 October 2016