Author: Oscar Cronquist Article last updated on September 06, 2018

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

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. Right-click on a data series and select "Add Data Labels".
  5. Double click 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 click 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 remaining line series.

How to wrap data label text

  1. Double click on the cell that contains the data label.
  2. Put the prompt between the words.
  3. Press Alt + Enter.
  4. Press Enter.

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. Click the "Align Left" button.

Download Excel *.xlsx file

Label series.xlsx