Author: Oscar Cronquist Article last updated on July 26, 2022

The chart above contains no legend instead data labels are used to show what each line represents.

line chart legene


1. How to build

  1. Insert a line chart.
  2. To label each line we need a cell range with the same size as the chart source data. Simply copy the chart source data range and paste it to your worksheet, then delete all data.
  3. All cells are now empty. Copy categories (Regions in this example) and paste to the last column (2018).
    Those correspond to the last data points in each series.
  4. Press with right mouse button on on a data series and select "Add Data Labels".
  5. Double press with left mouse button on with left mouse button on one of the data labels you just inserted to open the task pane window.
  6. Select checkbox "Value from cells".
  7. Select data label cell range we created earlier in step 3 and 4, that corresponds to the same line series. Use the legend to identify line series.
    In this example the data labels correspond to "South America", see image below.
  8. The data labels now show both numerical values and the last text value.

    To hide the numerical values simply double press with left mouse button on on the data labels to open the task pane.
  9. Deselect check box "Value".
  10. All numerical values are now deleted from the data labels, only the last data point has a data label, see image below.
  11. Position the data label to the right of the data point using the task pane.
  12. Resize the plot area so the data label doesn't collide with the line.
  13. Repeat step 4-12 with the remaining line series.

Back to top

2. How to wrap data label text

  1. Double press with left mouse button on the cell that contains the data label.
  2. Put the prompt between the words.
  3. Press Alt + Enter.
  4. Press Enter.

Back to top

3. Align data labels

  1. If you want the labels to be aligned to the left simply select the data label.
  2. Go to tab "Home" on the ribbon.
  3. Press with left mouse button on the "Align Left" button.

Back to top

Get Excel *.xlsx file

Label series.xlsx

Back to top