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!
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.
Great content as always! Just sharing, I find it easier to select the series by going to the Format Data Series pane on the right. Then the "Series Option" drop-down will give you the list of available series.👍🏾
Thank you! What if the “categorical variables” are of different scales? Eg. Instead of North, South, I want to do for two metrics LTV(a percentage value) and FICO score, for each metric, I have actual and target.
Very useful, is it possible to overlap only 2 series and and leave the rest as normal ? I have a bar chart of 5 series but i only meed to overlap 2 of them
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
Hey John, quick question if I wanted to do a fill bar by product how would I do that. Ie i have my overall targets but I want to show via fill which portion is a shoe, vs a brace, etc. In total I want the fill bar to go up to 20 but I want the shoe to take up 1/2 of it with a specific color and the brace to take up the other half.
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?
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
Hi jon, out of the topic, how make average by displaying the date ( 1 nov, 2 nov, 3 nov - 8 nov) in pivot table column ?? And values pivot "count of text"
I do appropriate your time If you can help us with the best chart type to present 2 levels data chart, example is below : London Men 300 Women 200 Total 500 Germany Men 400 Women 150 Total 550
Hi Maytham, Great question! Sometimes stacked charts are used for that type of data. However, stacked charts can be difficult to read. Here is an article that explains some alternatives. www.excelcampus.com/charts/dynamic-stacked-column-bar-chart-find-the-missing-trends/ I hope that helps. Thanks again and have a nice day! :-)
@@ExcelCampus Thank you for your time and reply. I feel Alternative #1 is not that practical as it need space to include all of Panel Charts in the report . Alternative #2 are good but when you put in report is hard to have it dynamic. For Alternative #3: what about Waterfall Chart or Stacked Column Bar Chart with adding total values on the top. appropriate your time to look at it again and suggest alternatives :).
hi John can you also teach us how to make the annual revenue trend chart? just subscribed. like the one shown in this video: th-cam.com/video/Tac611EcofI/w-d-xo.html
WOW. That video was so helpful. You explained everything so clear and simple. Great Job! Thanks, Jon!
Glad it was helpful! 😀
I just had an “aha!” moment with your tutorial. Thank you!!!! Super helpful!
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!
I just followed this video step by step and it is so clearly explained. I made a chart I love. Thanks so much 😊
Thanks Jon, excellent, very simple, easy steps but effective chart 👍👍
This video was very useful and very well explained all the concepts of excel chart, excellent !!
I can't thank you enough for this.. explained in a very simple able to understand manner..! Thanks once again
Super explanation. It's a great help. Thank you Jon!!!
Nice, clean charts. It amazes me how often I see badly formatted, ugly charts in business presentation. This video makes my eyes happy!
Haha awesome! I love it. Thanks Rico! 🙌
Great chart creation! Nice tricks to show this type of data too :) Thanks for sharing!
Great chart presentation!
This tutorial is very helpful. Thanks so much
Wow ! I will keep remember this trick. Literally helpful.
Thanks a bunch.
Thank you John for your valuable information
really its helped me to easier the work report... thanks for the post.. great work keep rocks
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.
Excellent sheet chart and easy methods
This is awesome. Def going to use this. Amazing! Thanks
Great Effort and easy way of explanation.
Very helpful, thank you John!
Great video. So useful. Thanks Jon.
Great content as always! Just sharing, I find it easier to select the series by going to the Format Data Series pane on the right. Then the "Series Option" drop-down will give you the list of available series.👍🏾
Displayed like a clear gem. Thank you Jon!
Really clever solution. New subscriber.
Thanks for the sub! :)
Thank you! What if the “categorical variables” are of different scales? Eg. Instead of North, South, I want to do for two metrics LTV(a percentage value) and FICO score, for each metric, I have actual and target.
Great stuff, this is what every business owner needs! Thank you Jon!!
Thank so much Paul! I appreciate it! 🙂👍
Outstanding info. Thanks
Our pleasure! 😊
Thanks so much!
Thanks for the help!!
Thank you guy
Thank you so much for this. This helped me out a lot!
YOURE THE MAN!
Ditto! Very useful . Thanks a lot. Logged for definite use!
it looks classy. that kind of simplistic beauty. 😄
Thanks!
Very useful, is it possible to overlap only 2 series and and leave the rest as normal ?
I have a bar chart of 5 series but i only meed to overlap 2 of them
Hey Jon, can you create a video on how to make a budget template or budget vs actual variance
I like this video. Thank you very much
I appreciate your support, Obeid! Thank you! 🙂
Wooow v nice presentation
Amazing !
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
Hey John, quick question if I wanted to do a fill bar by product how would I do that. Ie i have my overall targets but I want to show via fill which portion is a shoe, vs a brace, etc. In total I want the fill bar to go up to 20 but I want the shoe to take up 1/2 of it with a specific color and the brace to take up the other half.
Well done, thanks for sharing👍
Thank you Stephen! :-)
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?
Love it, thank you so much
Excellent 👍
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?
Well done...as always!
Thanks Robert! :-)
Hi Jon! Informative video! Did I miss the info what and why is +50 in =MAX function??
Very great tips, where Can i find your book about pie charts ?
Please could you show a demo month-to-month using the same scenario that you showed here.
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
I can't thank you enough!
Thank you
thanks for the video, i have a question, how to reverse from north in bottom to north in top? thanks
This really awesome !!!!
Good one
Hi there, I can't seem to find the link to download this chart?
Hi jon, out of the topic, how make average by displaying the date ( 1 nov, 2 nov, 3 nov - 8 nov) in pivot table column ?? And values pivot "count of text"
Is there a way to do this with a line graph?
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
How do I change the scale of the chart as I have branches with sales in the 100K's and in the Millions?
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
Can I overlap only 2 out of 5 bars?
I'm not sure there is a way to do that. You might need two separate charts.
Why it was label as targets instead of target?
I do appropriate your time If you can help us with the best chart type to present 2 levels data chart, example is below :
London
Men 300
Women 200
Total 500
Germany
Men
400
Women 150
Total 550
Hi Maytham,
Great question! Sometimes stacked charts are used for that type of data. However, stacked charts can be difficult to read. Here is an article that explains some alternatives.
www.excelcampus.com/charts/dynamic-stacked-column-bar-chart-find-the-missing-trends/
I hope that helps. Thanks again and have a nice day! :-)
@@ExcelCampus Thank you for your time and reply. I feel Alternative #1 is not that practical as it need space to include all of Panel Charts in the report . Alternative #2 are good but when you put in report is hard to have it dynamic.
For Alternative #3: what about Waterfall Chart or Stacked Column Bar Chart with adding total values on the top.
appropriate your time to look at it again and suggest alternatives :).
"Budget"...it means "Target"?
hi John can you also teach us how to make the annual revenue trend chart? just subscribed.
like the one shown in this video: th-cam.com/video/Tac611EcofI/w-d-xo.html
Great Effort and easy way of explanation
Amazing!
Excellent👍
Thanks Shahebaz! 😀