Make a BEAUTIFUL Budget vs. Actual chart in Excel 📊😍 (with adv. tricks)
Вставка
- Опубліковано 6 лип 2024
- 💥Download FREE Zebra BI tables add-in here 👉 bit.ly/3TAATU3
~
Ever wanted to make an impressive, kickass budget vs. actual (or plan vs. actual or target vs. actual) chart? In this simple but effective tutorial, let's build one using Excel. We are going to use few little-known tricks to make our chart truly extraordinary. Let's GO!!!
SAMPLE FILE 👇
=============
Need a hand with this chart? Check out the sample file here -
chandoo.org/wp/wp-content/upl...
⏱ VIDEO CHAPTERS 👇
===================
0:00 - Demo of the budget vs. actual chart
0:57 - Creating the bar chart & customising it
2:44 - Formulas for the variance & labels
5:43 - Setting the labels on the chart
6:48 - Formatting the chart
7:32 - What if I can't make such graphs in Excel? (Another AWESOME solution)
🦓 ZEBRA BI for Excel
==================
If you want to make an awesome budget vs. actual graph quickly, do check out the ZEBRA BI Excel Add-in. It gives you many ready to use options with just a click. Go here to download the add-in for free - zebrabi.com/excel-add-in/
Thank you ZEBRA BI for sponsoring this video 😀
🚦 More on KPIs, charting & data visualization in Excel 🖐
==============================================
Check out below tutorials & videos to learn more about KPIs, budget vs. actual charts in Excel.
📺 VIDEOS:
--------------------
Clickable report in Excel - • Make a clickable repor...
Dynamic chart in Excel - • Make an AWESOME Dynami...
Add a target line on your charts - • How to add a LINE to y...
Build a budget tracker in Excel - • How to make a Budget s...
Project Management Dashboard in Excel - • Make an awesome Projec...
HR Dashboard in Excel - • Make an Amazing HR Das...
📰 ARTICLES & TUTS:
------------------------------------
Beautiful Budget vs. Actual Chart in Excel - chandoo.org/wp/budget-vs-actu...
Target vs. Actual progress - Biker on a Hill dynamic chart - chandoo.org/wp/biker-on-hill-...
Target vs. Actual chart - Many options - chandoo.org/wp/charts-to-comp...
Simple KPI Dashboard using Excel - chandoo.org/wp/simple-kpi-das...
~
CONNECT WITH ME 🔗
📺 2nd channel (in Telugu) - / @data_with_chandoo
📷 Instagram (for tips & behind scenes) - / chandoo.xlsx
🐥 Twitter (fresh updates) - / r1c1
🌐 Website (1000+ articles, files) - chandoo.org/wp/
💡 Classes - chandoo.org/wp/excel-school-p...
~
#budget #excel
Have a beautiful day 😀🌞🌼 - Наука та технологія
Beautiful chart Chandoo. Thank you.
To be honest I liked the chart you made.
I really love and respect you CHANDOO, you’ve changed my understanding to excel and how t works, appreciate your efforts.
Amazing and awesome Chandoo. Thumbs up and hats off for such a wonderful input
This awesome!!!! Thank you for sharing😀
Love that formula and solution! Thank you!
Wonderful! Absolutely beautiful
This one damn good, very useful. Thank you very much.
This did a really good work for my chart. Thank you!!
Excellent Chandoo!
Awesome.Thank You ❤️❤️
Awesome 👌 report style...and thanks for Zebra Bi information.
As always, brilliant. Definitely going to have a play with Zebra.
Very thanks a lot Chandoo. Your content help me so much ☺️
Awesome....easy & impactful with sheer beauty...you are magical Mr. C ... remember na 😊 Thanks for sharing
awesome as usual
Love the enhanced animations bro ❤
Wow❤ great knowledge sharing
Thank you chandoo ❤
Thanks a lot chandoo
That was absolutely brilliant. Thank you so much!
I've always found Excel a bit ugly/clunky at data visualisation. Especially making a dashboard. It seems to take a lot of tinkering to make something that looks nice compared to PowerBi. This Kickass Chart really is and ups the game. Brilliant Chandoo. Very helpful.
This is awesome Chandoo.. can you also do a video on connecting Power query to SQL or Oracle or SAS directly to pull data? I wasn't successful, so wondering!
Very helpful
Kickass trick. Thanks da 😄
You are amazing @chandoo 😍😱
Very nice sir.,💐💐💐
Explanation is good sir
Thank you so much for the videos. I found you and this is been so helpful. Do you have any videos on hidden a column and protecting so no one opens but at the same time they are able to make changes to the rest of the worksheet?
Thank you
Lots of customisation.. available in Excel.. Wow..
One of the best ones I've seen so far, thank you for sharing!
Glad you enjoyed it!
Thanks! I am learning alot from you.. Happy Diwali✨✨
Man, I just love all your content!
Glad you enjoy it!
Hey Chandoo! Thanks for another amazing vídeo! Can you please tell me what computer you use? Is it still the same that you present in your setup video?
Thank you for awesome techniques 🙏🙏
Happy Diwali 🙏🙏
Great video, I will look for zebra as well. Thank you!
Let us know how you like it :)
Great Chandoo….
Pl make videos on advanced Waterfall charts
🙏🙏🙏🙏thank you
great
Happy Diwali Chandoo💥
Your tutoraial is very humorous and helpful. Thank you so much Chandoo. Do you know Chandoo is name of a Chinese city.
Awesome visual Chandoo. Is there any way we can create this same visual in Power Bi too.
This is crazy as a zebra 🦓
Have you tried it with your data already? :)
Thanks, that was awesome a quick question what if the figures are in millions
Thanks a lot, very nice tricks indeed. I am more interested in recreating the Zebra one, without the shape change of course, but just make like this with a drop down list to view different information.
HI, you can try it yourself - we have a 100% free version, too :)
Thank you Chandoo. it is really good chart but which printing or concerting it to pdf, it does'n show green or red signals. it shows black/gray only as shows in excel cells. Is there any solution for that?
😂😂😂😂 having fun while learning
Hey brother happy diwali anna.
You looks like an Vicky Kaushal
Could you kindly discount on Excel course
I like so much Power Bi. Indeed, a little slow for starting (5 min) , but really a big deal. To compare: excel needs less than 1 min on my 4 gb / 2,4 ghz lapi.
Happy diwali chandoo 😀🏮🏮
Happy Diwali to you too Anurag 😀
This is great. Does this method work when creating a calculation field in a pivot table?
Pivot Charts will show all the data in your Pivot Report. So one easy way to replicate this is to use Pivot for Actual & Target values and do the calculations outside and use that range to set up the chart. If you use "references" in the chart range, whenever your pivot changes (Refresh / slicer), the chart gets updated too.
Or just use the Zebra chart, which links up to pivots by default.
👏👏👏
I have problem with my data model in power bi
Can you pls help me....?
👏👏👏👏👏
I love you ❤
Hi i practiced . However in my excel red and green not shwoing after forming
do you create custom charts or templates
Yes, I do. Feel free to email me from chandoo.org/wp/contact
Hey chandu could you please let me know from where i need to start freelancer work i mean tell me the website name who provide work for freelancing work
what would the formula be if you wanted to show the variance as a percentage instead of absolute value?
You can use =this month / last month - 1 to get the % variance.
When I tried to do it with sample data, I got the emojis but not in colours, all emojis are reflecting black in the chart as well. Help me with this please.
hi, i have 10 line of data.. i was copied them from different sheet and I need to paste it to my excel sheet in column 2 , but i have some data in column 8 .. so how can I paste 10 lines of data without affecting 8th column of data
please help me
Chandoo thanks in advance.. I am using excel 2013 version , where I tried to insert emojis by using windows +. Keys simultaneously , but no emojis are reflecting. Can u help me on this...your videos are very nice..
Hi Srini... the emoji keypad is supported since Windows 8. (I think). So if you have a older version of Windows, you can use a site like emojipedia, search for the emoji you want, copy it and paste it in Excel.
@@chandoo_ thank you..
Nice chart chandoo. One issue in the chart, emojis are in black & white on the chart and not in color.
They should be in color in most new versions of Excel & Windows. What version are you using?
1st comment
The Zebra add-in is not showing up when I search for "zebra". Does that mean I don't have the best version of Excel? I have Office 2019.
Hmm.. not sure if it is compatible with 2019. Use the link to download the add-in - bit.ly/3TAATU3
Thanks! Do you Know why my emojis are in black and white?
You are welcome, Francesco. They always appear in black & white in the cells, but show up in color on the chart / textboxes in most recent versions of Excel. In future they might even show up in cells in color.
@@chandoo_ thank you so much