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

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

Charts category

How to create a dynamic chart
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]

Color chart columns based on cell color
This article demonstrates macros that automatically changes the chart bar colors based on the corresponding cell, the first example is […]

Line chart category

Highlight a data series in a line chart
This article demonstrates how to highlight a line in a chart based on the selected item in a drop-down list. […]

How to animate a line chart
This article demonstrates how to create an animation using a line chart in Excel. The user selects a series in […]

How to create a line chart
The line chart lets you chart data points as a line, this chart type is useful if you have many […]

Excel categories

Comments (3)