Add label to Excel chart line

Add label to Excel chart line

If you create line charts in Excel you may occasionally need to include labels to make it easier for the user to see what number the line is representing. Adding a label to an Excel line chart is very easy.

As shown below, you can create the chart and then right click on the line and choose ‘Add Data Labels’ and then ‘Add Data Labels’ again.

add-label-to-excel-chart-line

The labels are immediately put on the chart and Excel has ‘guessed’ that you wanted the values to appear. However, by right clicking on the labels you can customise what appears as labels. In the case below we have kept the values but note that we could use the series or category name. We also told Excel that the labels must appear above the line (Excel defaulted to the Right).
add-label-to-excel-chart-line