Creating charts to show Actual Vs Target

Recently I was working as part of a large training delivery (400 plus participants) where I was one of the helpers. One of the exercises was around comparing actual vs target in sales and creating a chart that showed that.

It required the use of an if function to help create the basis for the chart. I also thought it would be interesting (as you do..) to enhance the chart with a line to show the variance and another to show the Zero mark.

You can download the Starting file here.

I’ve done it for January in this video but in the completed file – you can see where I have done it for the three months.

You can download the completed file here. 

If you found this blog useful, why not give it a share?

Facebook
Twitter
LinkedIn
Pinterest
Reddit
Email
Print

Leave a Reply

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

nine + 13 =