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.
Step 4: Click on the chart and extend the data range to include the new column as well, so that it gets captured into the chart like shown below.
Step 5: Now right click on the new column's cell and click on Format cells and set the format as custom and type "Plan"