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.