• Dp

How To Add Legends To the Chart Itself In Excel; Smart way to show legends in chart

Updated: May 16, 2019

In this tutorial, I will show you an interesting trick in Excel on How To Add Direct Legends To the Chart Itself.


In this example, let us consider the data range as shown consisting of Plan and actuals for 6 months.


Step 1: Let us plot the chart from the quick analysis tool like this.

Step 2: The normal line chart will be generated like this

Step 3: Now, let us enter the values of last column into a new column, which will be an extra column now.