• Dp

Best Way To Create Plan Vs Actual Graph In Excel || dptutorials

In this tutorial, let us learn the best way to create a plan vs actual graph in Excel.

This chart as shown on the 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