Make a BEAUTIFUL Budget vs. Actual chart in Excel 📊😍 (with adv. tricks)

[@nsanch0181]

Beautiful chart Chandoo. Thank you.

[@Bhavik_Khatri]

To be honest I liked the chart you made.

[@srinivasr1283]

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!

[@abdulla.]

I really love and respect you CHANDOO, you’ve changed my understanding to excel and how t works, appreciate your efforts.

[@QuantuMatrix]

Amazing and awesome Chandoo. Thumbs up and hats off for such a wonderful input

[@MaureenPesch]

Love that formula and solution! Thank you!

[@DarrenStarr]

That was absolutely brilliant. Thank you so much!

[@DarrenStarr]

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.

[@arvindr2101]

This one damn good, very useful. Thank you very much.

[@s1mba3]

One of the best ones I've seen so far, thank you for sharing!

[@chandoo_]

Glad you enjoyed it!

[@chrism9037]

Excellent Chandoo!

[@lavelclaytorsProjectswPurpose]

This awesome!!!! Thank you for sharing😀

[@excelangola2727]

You are amazing @chandoo 😍😱

[@TP014563]

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.

[@ZebraBI]

HI, you can try it yourself - we have a 100% free version, too :)

[@cherylbarnes327]

Hi Chandoo. Beautiful chart. What happens if one of your seven of your variables variance is in millions, does the "K" still apply

[@techcorner2024]

Wonderful! Absolutely beautiful

[@shabchique7149]

Great video, I will look for zebra as well. Thank you!

[@ZebraBI]

Let us know how you like it :)

[@eroteam2]

Man, I just love all your content!

[@chandoo_]

Glad you enjoy it!

[@ryanyang2486]

Your tutoraial is very humorous and helpful. Thank you so much Chandoo. Do you know Chandoo is name of a Chinese city.

[@operationbroomstick]

Love the enhanced animations bro ❤

[@MrDhunpagla]

Awesome....easy & impactful with sheer beauty...you are magical Mr. C ... remember na 😊 Thanks for sharing

[@kieranholland5494]

As always, brilliant. Definitely going to have a play with Zebra.

[@dennywu8536]

Very thanks a lot Chandoo. Your content help me so much ☺️

[@usman5402]

Thank you chandoo ❤

[@Abilash62]

This did a really good work for my chart. Thank you!!

[@canrick]

Thanks a lot chandoo

[@BilalAhmad-pi3ds]

awesome as usual

[@AP-eb8hd]

Lots of customisation.. available in Excel.. Wow..

[@riteshzope3672]

Great Chandoo…. Pl make videos on advanced Waterfall charts

[@foodcity9875]

Wow❤ great knowledge sharing

[@arbazahmad7177]

Awesome 👌 report style...and thanks for Zebra Bi information.

[@vargheseantony5677]

Awesome.Thank You ❤️❤️

[@hansklein3649]

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.

[@belkisgarcia2674]

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?

[@taizoondean689]

Thank you for awesome techniques 🙏🙏

[@taizoondean689]

Happy Diwali 🙏🙏

[@gkdsama]

Kickass trick. Thanks da 😄

[@Sirigineedi_Navann]

Hey brother happy diwali anna. You looks like an Vicky Kaushal

[@excellnewbie4988]

Very helpful

[@pandharinathjoshi6565]

Very nice sir.,💐💐💐 Explanation is good sir

[@lluisrodoreda]

This is crazy as a zebra 🦓

[@ZebraBI]

Have you tried it with your data already? :)

[@DisneyA-e9p]

Thanks, that was awesome a quick question what if the figures are in millions

[@clubedavid]

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?

[@manishgoyal5971]

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?

[@piyushsanwal5696]

Awesome visual Chandoo. Is there any way we can create this same visual in Power Bi too.

[@MichaelNgotho]

Chandoo, I got the trial version. But I can’t seem to get the chart that you used for this video?

[@anuragsaklani2951]

Happy diwali chandoo 😀🏮🏮

[@chandoo_]

Happy Diwali to you too Anurag 😀

[@srirambalan6060]

Happy Diwali Chandoo💥

[@satishkhubchandani520]

Thanks! I am learning alot from you.. Happy Diwali✨✨

[@hadjidjilali8034]

Thank you

[@kartikpoojari9663]

🙏🙏🙏🙏thank you

[@22bdickson]

This is great. Does this method work when creating a calculation field in a pivot table?

[@chandoo_]

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.

[@abdullahalwaheed2527]

Could you kindly discount on Excel course

[@CandiceMacBride]

what would the formula be if you wanted to show the variance as a percentage instead of absolute value?

[@chandoo_]

You can use =this month / last month - 1 to get the % variance.

[@HagaagAccounting]

😂😂😂😂 having fun while learning

[@SahinEkwal]

great

[@rehobothllc1]

do you create custom charts or templates

[@chandoo_]

Yes, I do. Feel free to email me from chandoo.org/wp/contact

[@wrtmsg2abhi]

Nice chart chandoo. One issue in the chart, emojis are in black & white on the chart and not in color.

[@chandoo_]

They should be in color in most new versions of Excel & Windows. What version are you using?

[@srinivasarajuraju8305]

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..

[@chandoo_]

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.

[@srinivasarajuraju8305]

@@chandoo_ thank you..

[@bansdeepkumar]

I have problem with my data model in power bi Can you pls help me....?

[@qaleelahmed-official8233]

Hi i practiced . However in my excel red and green not shwoing after forming

[@manindarsingh6095]

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

[@tejaa07]

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.

[@Manojkumar__]

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

[@Manojkumar__]

please help me

[@Dreamylife0111]

I love you ❤

[@markmarogil2228]

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.

[@chandoo_]

Hmm.. not sure if it is compatible with 2019. Use the link to download the add-in - bit.ly/3TAATU3

[@lealeveriza4497]

👏👏👏

[@estivisonmc]

👏👏👏👏👏

[@francescox79]

Thanks! Do you Know why my emojis are in black and white?

[@chandoo_]

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.

[@francescox79]

@@chandoo_ thank you so much

[@IamBetterThanYou0]

Thnx but it doesn't work in Excel 2016

[@sawaimalhi8439]

1st comment