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