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
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?
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.
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
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 had an “aha!” moment with your tutorial. Thank you!!!! Super helpful!
WOW. That video was so helpful. You explained everything so clear and simple. Great Job! Thanks, Jon!
Glad it was helpful! 😀
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! 🙌
This video was very useful and very well explained all the concepts of excel chart, excellent !!
I just followed this video step by step and it is so clearly explained. I made a chart I love. Thanks so much 😊
I can't thank you enough for this.. explained in a very simple able to understand manner..! Thanks once again
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 chart presentation!
Super explanation. It's a great help. Thank you Jon!!!
Thanks Jon, excellent, very simple, easy steps but effective chart 👍👍
YOURE THE MAN!
This tutorial is very helpful. Thanks so much
Thank you John for your valuable information
Excellent sheet chart and easy methods
Wow ! I will keep remember this trick. Literally helpful.
Thanks a bunch.
really its helped me to easier the work report... thanks for the post.. great work keep rocks
Great chart creation! Nice tricks to show this type of data too :) Thanks for sharing!
Great Effort and easy way of explanation.
Very helpful, thank you John!
This is awesome. Def going to use this. Amazing! Thanks
Displayed like a clear gem. Thank you Jon!
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.👍🏾
Great stuff, this is what every business owner needs! Thank you Jon!!
Thank so much Paul! I appreciate it! 🙂👍
Really clever solution. New subscriber.
Thanks for the sub! :)
Thanks for the help!!
Outstanding info. Thanks
Our pleasure! 😊
Thanks so much!
Hey Jon, can you create a video on how to make a budget template or budget vs actual variance
it looks classy. that kind of simplistic beauty. 😄
Well done...as always!
Thanks Robert! :-)
Thank you so much for this. This helped me out a lot!
Ditto! Very useful . Thanks a lot. Logged for definite use!
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
Thank you guy
Please could you show a demo month-to-month using the same scenario that you showed here.
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
I can't thank you enough!
Wooow v nice presentation
Well done, thanks for sharing👍
Thank you Stephen! :-)
I like this video. Thank you very much
I appreciate your support, Obeid! Thank you! 🙂
Love it, thank you so much
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?
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?
Thanks!
Very great tips, where Can i find your book about pie charts ?
Amazing!
Excellent👍
Thanks Shahebaz! 😀
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.
thanks for the video, i have a question, how to reverse from north in bottom to north in top? thanks
Hi Jon! Informative video! Did I miss the info what and why is +50 in =MAX function??
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
This really awesome !!!!
Thank you
Is there a way to do this with a line graph?
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"
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
Good one
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?
Why it was label as targets instead of target?
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.
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
Excellent 👍
Amazing !