How To Create An Actual Vs Target Chart In Excel

Hi there, I can't seem to find the link to download this chart?

I hope I get the help I need. I work with a team with multiple targets (Phone sales, data device sale and sim activation). I want to design an interactive dashboard where all the individuals along their performances in all of the 3 KPIs appear

Can I overlap only 2 out of 5 bars?

well..its just for one instance. How do we do it for a period trend. I have 12 months of data with each of these attributes

Thanks so much!

Thank you for the video! I currently use a sales target tracking template I got from Someka, however, I was wondering if it's possible to download this chart?

This video was very useful and very well explained all the concepts of excel chart, excellent !!

Is there a way to do this with a line graph?

Please could you show a demo month-to-month using the same scenario that you showed here.

Thanks for this video..just found it. What if the bar chart are clustered? Can we overlap the bar size and kept showing as clustered bar?

Amazing !

I have been wondering how to make a bullet bar chart with a vertical target line. I only knew how to make this type of bullet bar chart where the target was a dot. Thank you so much for this video.

Thanks!

Thanks Jon, excellent, very simple, easy steps but effective chart 👍👍

Super explanation. It's a great help. Thank you Jon!!!

Great chart creation! Nice tricks to show this type of data too :) Thanks for sharing!

Very great tips, where Can i find your book about pie charts ?

Thank you guy

Great chart presentation!

This is awesome. Def going to use this. Amazing! Thanks

really its helped me to easier the work report... thanks for the post.. great work keep rocks

it looks classy. that kind of simplistic beauty. 😄

I can't thank you enough for this.. explained in a very simple able to understand manner..! Thanks once again

"Budget"...it means "Target"?

Tried this chart but I can't seem to have the data labels for the variance go at the center or end of the bar chart. It stays at the left end. Help

I can't thank you enough!

Hey Jon, can you create a video on how to make a budget template or budget vs actual variance

I just followed this video step by step and it is so clearly explained. I made a chart I love. Thanks so much 😊

YOURE THE MAN!

thanks for the video, i have a question, how to reverse from north in bottom to north in top? thanks

Thanks for the help!!

Hi Jon! Informative video! Did I miss the info what and why is +50 in =MAX function??

Wooow v nice presentation

Amazing!

This tutorial is very helpful. Thanks so much

Very helpful, thank you John!

I cannot tell you how grateful I am for your videos! This one on Actuals vs Targets especially! I moved into management a few years ago and FORGOT half of what I knew of Excel and I was no expert back then! But I have to justify a need for more headcount and was stressing how I could represent the no. of hours my staff are working vs a baseline. This video saved my job! And I am 100% confident the data tells exactly the story I need to!! Thank you for these! I am sooo going to be sticking with Elevate Excel for life!

Outstanding info. Thanks

Really clever solution. New subscriber.

Thank you so much for this. This helped me out a lot!

Wow ! I will keep remember this trick. Literally helpful.
Thanks a bunch.

Excellent Jon, very helpful,
my question is: How can I make Target Vs Actual like this using Pivot Table and Pivot Charts with different filters?
thanks so much in advance

How do I change the scale of the chart as I have branches with sales in the 100K's and in the Millions?

Displayed like a clear gem. Thank you Jon!

Excellent 👍

I just had an “aha!” moment with your tutorial. Thank you!!!! Super helpful!

Good one

This really awesome !!!!

Great Effort and easy way of explanation