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

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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *