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!
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.
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.
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?
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?
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?
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.
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
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.
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.
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
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.
Beautiful chart Chandoo. Thank you.
Amazing and awesome Chandoo. Thumbs up and hats off for such a wonderful input
I really love and respect you CHANDOO, you’ve changed my understanding to excel and how t works, appreciate your efforts.
To be honest I liked the chart you made.
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!
Awesome....easy & impactful with sheer beauty...you are magical Mr. C ... remember na 😊 Thanks for sharing
This awesome!!!! Thank you for sharing😀
You are amazing @chandoo 😍😱
Love that formula and solution! Thank you!
One of the best ones I've seen so far, thank you for sharing!
Glad you enjoyed it!
Excellent Chandoo!
Great video, I will look for zebra as well. Thank you!
Let us know how you like it :)
Very thanks a lot Chandoo. Your content help me so much ☺️
This one damn good, very useful. Thank you very much.
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.
Man, I just love all your content!
Glad you enjoy it!
Wow❤ great knowledge sharing
Thank you chandoo ❤
Love the enhanced animations bro ❤
Wonderful! Absolutely beautiful
Awesome 👌 report style...and thanks for Zebra Bi information.
Very nice sir.,💐💐💐
Explanation is good sir
Your tutoraial is very humorous and helpful. Thank you so much Chandoo. Do you know Chandoo is name of a Chinese city.
As always, brilliant. Definitely going to have a play with Zebra.
Great Chandoo….
Pl make videos on advanced Waterfall charts
Hi Chandoo. Beautiful chart. What happens if one of your seven of your variables variance is in millions, does the "K" still apply
Thank you for awesome techniques 🙏🙏
Happy Diwali 🙏🙏
This did a really good work for my chart. Thank you!!
Thanks a lot chandoo
awesome as usual
Chandoo, I got the trial version. But I can’t seem to get the chart that you used for this video?
Awesome.Thank You ❤️❤️
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 :)
Kickass trick. Thanks da 😄
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?
Lots of customisation.. available in Excel.. Wow..
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?
Thanks! I am learning alot from you.. Happy Diwali✨✨
Awesome visual Chandoo. Is there any way we can create this same visual in Power Bi too.
Very helpful
Thanks, that was awesome a quick question what if the figures are in millions
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?
Happy Diwali Chandoo💥
do you create custom charts or templates
Yes, I do. Feel free to email me from chandoo.org/wp/contact
Thank you
Hi i practiced . However in my excel red and green not shwoing after forming
Hey brother happy diwali anna.
You looks like an Vicky Kaushal
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.
This is crazy as a zebra 🦓
Have you tried it with your data already? :)
🙏🙏🙏🙏thank you
Happy diwali chandoo 😀🏮🏮
Happy Diwali to you too Anurag 😀
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.
I have problem with my data model in power bi
Can you pls help me....?
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.
Could you kindly discount on Excel course
😂😂😂😂 having fun while learning
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
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?
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.
great
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..
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
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
👏👏👏
👏👏👏👏👏
I love you ❤
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
1st comment
Thnx but it doesn't work in Excel 2016