Impress your boss with Waffle Charts in Excel - Easy Recipe
Ғылым және технология
Waffle time 🧇🧇🧇😋
Do you want to add a little bit of WOW factor to your upcoming report or presentation? Why not try a WAFFLE chart. They are easy to cook and sure to win everyone's hearts & eyes.
📗Download the sample workbook:
=============================
Here is a sample workbook with the chart(s) 👉 chandoo.org/wp/wp-content/upl...
⏱ In this video:
=============
0:00 - Waffle chart in Excel - DEMO
0:57 - Waffle chart instructions
2:16 - Using SEQUENCE function to make up the numbers
3:11 - Using SORT to flip the waffle
4:00 - Formatting the Waffle Chart
5:25 - Adding a label
📈📊📉 MORE CHARTS:
====================
Dynamic Excel Chart with Checkboxes - • Make an AWESOME Dynami...
Easiest Dashboard Trick (link up two charts) - • Link up two charts to ...
Lollipop Chart in Excel 🍭 - • Try this yummy Lollipo...
WAFFLE Chart in Power BI - • 🧇 Yummy WAFFLE Chart i...
Charting Playlist - • Make impressive infogr...
~
What do you call the top left corner of a waffle?
A1 of course 😂
#excelcharts #datavisualization
Пікірлер: 91
Bro you are so consistent in producing videos, following you since ur website days...ver very old follower
@chandoo_
2 жыл бұрын
Thanks OMV for being with me on this amazing journey. More power to you 😎
@enochjf
2 жыл бұрын
Wish you all the best
It's always the simple little side details that make your videos work. I just learned how to link the text box to the cell value. I will be using that a lot.
A real master in your domain. Thank you so much Chandoo
The beauty of this video is in its SIMPLICITY. While the video is informative, I found the SORT & SEQUENCE formula mighty informative too. Thank You!
Brilliant and so easy!
@chandoo_
2 жыл бұрын
Glad you think so.
Wow, simple elegant, I love it
@chandoo_
2 жыл бұрын
Thank you! 😊
It’s really good. Thank you.
@chandoo_
2 жыл бұрын
You are welcome Janardan
Every time there's something new to learn from you. Keep up the good work and keep inspiring 👍
@chandoo_
2 жыл бұрын
You are welcome Anand...
Awesome Chandoo!
@chandoo_
2 жыл бұрын
You are welcome Chris.
Love your channel! Keep going, Sir!
@chandoo_
2 жыл бұрын
Much appreciated!
Too good
Amazing, learning visualization + introduction to the new formula with Fun ! Thank you Chandoo for sharing this , Good Day ! Regards
@chandoo_
2 жыл бұрын
The whole package 🎁
Thank you. Cool one.
@chandoo_
2 жыл бұрын
😎
Great stuff! Very easy to follow and to replicate! Thank you!
@chandoo_
2 жыл бұрын
Glad it was helpful!
This is magical sir. Thank you so much for inspiring we the upcoming ones. Your tutorials are just classic
@chandoo_
2 жыл бұрын
You are welcome KT...
These short hack vedios are awesome 😍💐
@chandoo_
2 жыл бұрын
Glad to hear that Shashank.
Very informative. It is also useful for parents teaching thier kids about fractions with whole numbers or decimals.
@chandoo_
2 жыл бұрын
Yes, definitely
❤️🇮🇳❤️🇮🇳❤️🇮🇳❤️🇮🇳❤️🇮🇳❤️🇮🇳❤️ Very beautiful sir, more visualisation interactive charts in Excel like waffle, butterfly etc charts.
Awesome...really helpful
@chandoo_
2 жыл бұрын
You are welcome Rana.
that was perfect
@chandoo_
2 жыл бұрын
You are welcome :)
Small Token of Gratitude!
@chandoo_
2 жыл бұрын
Thanks for the Super Ankur 😎😍
Thank you sir 👍🙏
@chandoo_
2 жыл бұрын
You are welcome TD...
This is so cool
@chandoo_
2 жыл бұрын
and yummy too...
Great 👍
@chandoo_
2 жыл бұрын
thank you :)
Спасибо, очень актуально, всё пошагово объяснено!!! 🥰🥰🥰
@chandoo_
2 жыл бұрын
dobro pozhalovat 😊
Thx for share g 🙏
@chandoo_
2 жыл бұрын
You are welcome 😀
You are genius no words really 🥰
@chandoo_
2 жыл бұрын
And now you know my tricks 😎
I was trying to think of a graphic solution for an office building seating chart, 5 floors high, for each day of the week in a hybrid work model that show who is in/out on any floor on any day. This might work!
Hi Chandoo. Loved the idea. Thanks for bringing this to us. I've made a small variation on your idea using percentages and 10x10 grids to allow any top value. Wish you could see 😁 Very proud of me today 😊
@chandoo_
2 жыл бұрын
Wow.. Mission Accomplished! More power ⚡to you 😀
Can also use the Top/ bottom Conditional formatting entering a cell reference to the bottom 350.
@chandoo_
2 жыл бұрын
That is another great idea...
you inspired me to buy and eat a waffle
@chandoo_
2 жыл бұрын
YUMM 😋
Hi Chandu... Can u help me i want to create a stack tally sheet for stacking some item in warehouse it should show all life cycle details of receipt & despatch along with balance for 1 peticular item Attributes required 1 batch/Lot No 2 qty received in(red) 3. qty despatched (blue) 4 every receipt & despatch entry will hav balance left at last column..... I have all receipt details of all item in one sheet and all despatch details in another sheet with different column headings
Thanks for the great video! How can I centralise the text label within the waffle? TIA
@chandoo_
2 жыл бұрын
You can apply alignment on it.
I want to make my career as a Data Analyst. How and from where I should start ?
very nice ! can we make something like that in a PowerBI dashboard ?
@chandoo_
2 жыл бұрын
You can. I have a Power BI Waffle tutorial here - kzread.info/dash/bejne/gY6ExZZrqNHcaNY.html
Excellent video but is it possible to do the same thing without SEQUENCE as I have Excel 2019. Thank you for all your great videos.
@chandoo_
2 жыл бұрын
You can use ROWS() function to generate running numbers. For ex. =ROWS(A1:$A$20) in A1 will give you 20 and when you drag it down, you should get 19,18...1.
@andrewbishop9467
2 жыл бұрын
@@chandoo_ Thank you for your help.
Off topic question but what watch are you wearing in this video!
@chandoo_
2 жыл бұрын
It is a Titan watch. Not sure about the model.
Sir, in my 2016 excel sheet =sequence is not showing, what to do? 😇
@vishalbhati912
2 жыл бұрын
It's only in office 365
@RAJESHS-df8io
2 жыл бұрын
@@vishalbhati912 thanks vishal
Since you are a wizard .. i would like to know is there a way i can automate my youtube channel views and subscribers to update on excel sheet
How did you get only the last text box (the one that has the least weight) in bold?
@chandoo_
2 жыл бұрын
I manually did it as it is a one off thing.
@ajieapen
2 жыл бұрын
@@chandoo_ Ah... I thought there was some trick that you used... :D
thank you so much providing the information. as student, i am asking you, i have a little bit concerned. " please guide me", i have been working those technologies Advance Excel and VBA macros , Power Bi and Microsoft SQL server Database. 1) while giving an interview , they are saying VBA is outdated, still you are in VBA and they are suggested get python . 2) at present in India , there is not a calls in power Bi, people are suggested tableau is best. finally i am done ,i have mentioned in profile, "python and power Bi , SQL server database and Excel is it good profile? Please say me, how will I get Power Bi calls
@chandoo_
2 жыл бұрын
No one can tell you what is good. Each of us are unique and gifted with some talents. My advise is simple: 1) Call up a few of the recruiters and ask them for honest, no-holds barred feedback on why they rejected you. You might be surprised. 2) You CAN keep multiple profiles and use the right one for a job opening. 3) Good things take time. If you feel like you are waiting too long, don't hesitate to take up something else. 4) Stop asking "what is best" and start asking "what is the best for this job + company + situation" and see how you can offer that. All the best.
@Munichandra_Reddy
2 жыл бұрын
@@chandoo_ thank thank you so much for your valuable ideas and wishes
I have seen your data analytics excel pro course in just 49 minutes that was really a good learning video. Sir is it possible to get a data analyst job without bechelor degree. I am persuing Google data analytics professional certificate on coursera and that is really an awesome course but, sometimes getting demotivated because of bachelor degree. sir it is possible to get a job in abroad with Google data analytics Coursera's professional certificate.
@chandoo_
2 жыл бұрын
Thanks for your comments OFS. While companies are loosening their policies, it is still tricky to land your first job without some sort of degree. If you are young and have time, why not finish the degree? There are many distance & part-time options available now a days.
@onlinefunscreen
2 жыл бұрын
@@chandoo_ sir i am studying bachelor in civil engineering in 4th year but i have no more interest in it i wanna transit my career in data science. Is bachelor in civil engineering can help me join study master course in data science.
Sleek.. I sometimes use white font :-) instead of ";;;"
@chandoo_
2 жыл бұрын
I suggest using the ;;; for such things.
Can you help me to get result Input- ram Output - "ram"
@chandoo_
2 жыл бұрын
Not sure I understand. The input is same as output. If you want to add the quotes, you can use ="""" & A1 & """"
@niteshagarwal478
2 жыл бұрын
@@chandoo_ Tysm.... I was using 3 quotes so was unable to get results... We have to use 4 quotes.... Your videos are awesome... I m loving it😋
This is so nerdy... id like to find an excuse to use this.
I love all your videos, but not able to wrap my head around why would i create this chart. It’s taking too much space and doesn’t provide the clear comparison between different numbers. Nevertheless nice work on sharing this.
@chandoo_
2 жыл бұрын
I would use this kind of a chart in a presentation or info-graphic style report. Not in regular dashboards as it doesn't offer a great data to ink ratio.
Looks useless!
@chandoo_
2 жыл бұрын
Disagree.