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!
@jiajiaphotography
3 жыл бұрын
I just followed this video step by step and it is so clearly explained. I made a chart I love. Thanks so much 😊
@q.chenelle9690
4 жыл бұрын
I just had an “aha!” moment with your tutorial. Thank you!!!! Super helpful!
@ricos1497
4 жыл бұрын
Nice, clean charts. It amazes me how often I see badly formatted, ugly charts in business presentation. This video makes my eyes happy!
@ExcelCampus
4 жыл бұрын
Haha awesome! I love it. Thanks Rico! 🙌
@rathanraj83
3 жыл бұрын
I can't thank you enough for this.. explained in a very simple able to understand manner..! Thanks once again
@cshahed
2 жыл бұрын
Thanks Jon, excellent, very simple, easy steps but effective chart 👍👍
@MichaelBrown-lw9kz
Жыл бұрын
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.
@manjunathsundaram8201
Жыл бұрын
This video was very useful and very well explained all the concepts of excel chart, excellent !!
@PeterPeters-86
5 ай бұрын
WOW. That video was so helpful. You explained everything so clear and simple. Great Job! Thanks, Jon!
@ExcelCampus
5 ай бұрын
Glad it was helpful! 😀
@IvanCortinas_ES
2 жыл бұрын
Super explanation. It's a great help. Thank you Jon!!!
@rotethongvanit
2 жыл бұрын
Great chart presentation!
@ziabashir
4 жыл бұрын
Excellent sheet chart and easy methods
@euniceesinam2573
3 жыл бұрын
This tutorial is very helpful. Thanks so much
@farithahamed3599
4 жыл бұрын
Thank you John for your valuable information
@tonyagamata2874
4 жыл бұрын
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.👍🏾
@maythamalmouthen5191
4 жыл бұрын
Great Effort and easy way of explanation.
@harishnegi0903
4 жыл бұрын
Wow ! I will keep remember this trick. Literally helpful. Thanks a bunch.
@yousefkamhiyah2536
3 жыл бұрын
YOURE THE MAN!
@RameshKumar-qu3cu
3 жыл бұрын
really its helped me to easier the work report... thanks for the post.. great work keep rocks
@RAEN74
2 жыл бұрын
This is awesome. Def going to use this. Amazing! Thanks
@SpotlightImpact
2 жыл бұрын
Great chart creation! Nice tricks to show this type of data too :) Thanks for sharing!
@mohammedagag6509
4 жыл бұрын
Very helpful, thank you John!
@TomHenson
3 жыл бұрын
Thanks for the help!!
@jesuspabloalvarezvidal8089
Жыл бұрын
Thanks so much!
@anillpatel
4 жыл бұрын
Great video. So useful. Thanks Jon.
@JJ-wx3nd
3 күн бұрын
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.
@patrickwilson2075
4 жыл бұрын
Outstanding info. Thanks
@ExcelCampus
4 жыл бұрын
Our pleasure! 😊
@chengwang411
3 жыл бұрын
it looks classy. that kind of simplistic beauty. 😄
@evardoreinp7980
2 жыл бұрын
Thank you guy
@catherinemccauley8109
4 жыл бұрын
Displayed like a clear gem. Thank you Jon!
@NigelMayhew1
2 жыл бұрын
Thanks!
@mans0011
4 жыл бұрын
Really clever solution. New subscriber.
@ExcelCampus
4 жыл бұрын
Thanks for the sub! :)
@paulhowell4257
4 жыл бұрын
Great stuff, this is what every business owner needs! Thank you Jon!!
@ExcelCampus
4 жыл бұрын
Thank so much Paul! I appreciate it! 🙂👍
@arabianoud3812
3 жыл бұрын
Wooow v nice presentation
@joielou6544
Жыл бұрын
Amazing !
@asifazad6625
Жыл бұрын
Please could you show a demo month-to-month using the same scenario that you showed here.
@myhouseuganda
3 жыл бұрын
Hey Jon, can you create a video on how to make a budget template or budget vs actual variance
@suhailnbd
4 жыл бұрын
Excellent 👍
@TheSheikha
3 жыл бұрын
I can't thank you enough!
@ObeidAlharbi
4 жыл бұрын
I like this video. Thank you very much
@ExcelCampus
4 жыл бұрын
I appreciate your support, Obeid! Thank you! 🙂
@omerhumeida7166
6 ай бұрын
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
@RobertAfrick
4 жыл бұрын
Well done...as always!
@ExcelCampus
4 жыл бұрын
Thanks Robert! :-)
@jeannetteabrahamson5342
4 жыл бұрын
Thank you so much for this. This helped me out a lot!
@EricaDyson
4 жыл бұрын
Ditto! Very useful . Thanks a lot. Logged for definite use!
@stephenbrincat7124
4 жыл бұрын
Well done, thanks for sharing👍
@ExcelCampus
4 жыл бұрын
Thank you Stephen! :-)
@giaphu9141
4 жыл бұрын
Thank you
@97grad
4 жыл бұрын
Love it, thank you so much
@andrewgamal4437
4 жыл бұрын
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
@rhonalkhairul3969
Жыл бұрын
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?
@mirrrvelll5164
3 жыл бұрын
Hi Jon! Informative video! Did I miss the info what and why is +50 in =MAX function??
@davehansel9715
Жыл бұрын
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?
@babajideamure108
Жыл бұрын
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
@punksit015
3 жыл бұрын
thanks for the video, i have a question, how to reverse from north in bottom to north in top? thanks
@TheLaopi
2 жыл бұрын
Very great tips, where Can i find your book about pie charts ?
@puthur1
4 жыл бұрын
Good one
@sallyho146
Ай бұрын
Why it was label as targets instead of target?
@MohamedMostafa-dm9qy
4 жыл бұрын
This really awesome !!!!
@arindambhattacharya7848
Жыл бұрын
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
@masarushibata6143
Жыл бұрын
Hi there, I can't seem to find the link to download this chart?
@stephensheets9614
Жыл бұрын
Is there a way to do this with a line graph?
@appleacosta7126
3 жыл бұрын
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
@chichinovrian1495
4 жыл бұрын
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"
@stevesulea4968
4 жыл бұрын
How do I change the scale of the chart as I have branches with sales in the 100K's and in the Millions?
@EstaCarla
Жыл бұрын
Can I overlap only 2 out of 5 bars?
@ExcelCampus
Жыл бұрын
I'm not sure there is a way to do that. You might need two separate charts.
@maythamalmouthen5191
4 жыл бұрын
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
@ExcelCampus
4 жыл бұрын
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! :-)
@maythamalmouthen5191
4 жыл бұрын
@@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 :).
@ttlcth9082
3 жыл бұрын
"Budget"...it means "Target"?
@michaelallen7172
6 ай бұрын
hi John can you also teach us how to make the annual revenue trend chart? just subscribed. like the one shown in this video: kzitem.info/news/bejne/tZeZnGVnfpWgmX4
Пікірлер: 83