About this tutorial:
Video duration: 2:58
In this tutorial, let us learn the best way to create plan vs actual graph in Excel.
This chart as shown on left side is what generally people tend to use.
Now see on to the right side this is what i prefer the most, because this adds value to your visual reports.
Now let’s get into the working file to see how it is done.
1. First, Select the entire data set.
2. Go to Insert tab
3. In the charts section, click on the 2D clustered Column Chart
4. Chart gets created, To Change the look of the Plan values. Click on any of the bars of Plan values. Right click and select ‘Change Series…