These “recreating visuals” videos are super useful. Thanks. Part 2 and part 3 please
@KenjiExplains11 ай бұрын
Noted thank you :)
@oscarjuarez338611 ай бұрын
Keep them coming!
@HarryPotterFan130711 ай бұрын
Definitely a part two and three!!! These dashboard videos are the best on KZbin!
@KenjiExplains11 ай бұрын
Glad you like them! More to come hopefully
@daviddigridi79496 ай бұрын
@@KenjiExplainsplease waiting for the part 2
@Thatrandomgirl711 ай бұрын
I have just started learning excel and your video are giving me confidence and ample knowledge to go in this path
@Jan-sd6nc11 ай бұрын
Yes we want a part two. These videos are very helpful for me.
@KenjiExplains11 ай бұрын
Noted thank you!
@vodkayan21010 ай бұрын
Yes, looking forward to part2 and 3, thanks Kenji!@@KenjiExplains
@Sailingbill12 ай бұрын
This is one of the only pragmatic video's I have seen. Thank you for taking the time to do this!
@deruan76257 ай бұрын
Super useful Kenki, thanks so much. FYI the second chart is a Stacked Bar Chart, to compare frequencies over a 2 parameters of a variables, let's say freqs of Yes and No over a variable like "Hold a bachelor degree" over a range of years or age population ranges. It would be nice a video like this but making some ppts in McKinsey style as they recently changed their branding a bit
@VINAY_DEVADIGA7 ай бұрын
In the Unnamed chart, --> Alternatively you can also create a horizontal range of the values of Year and Quarter, create a linked image through the excel's built in Camera tool and then Format and Resize it as convenient and finally place it on top of the chart, saves a bit of time!!
@maniimanii176611 ай бұрын
Downloaded Excel today, literally found your page yesterday and the quality of content you create is amazing, more visuals please!
@KenjiExplains11 ай бұрын
Awesome, thank you! more soon hopefully :)
@MarkJones-bc5vx5 ай бұрын
Fantastic examples. You explain making charts in an easy to understand way.
@happymystic980011 ай бұрын
Nice work packed inside an instructive video. A part 2:and 3 would be a perfect roundup of more charts in the McKinsey arsenal. Cheers …
@amospan1411 ай бұрын
Really appreciate these recreating visuals walkthroughs. They come in handy, thank you! =)
@KenjiExplains11 ай бұрын
You're very welcome!
@Max-qy1dw10 ай бұрын
McKinsey uses as Ppt add in called Thinkcell. With such tool it takes you 30 seconds to build charts. Doing it in Excel is really inefficient.
@violentfox10 ай бұрын
Well, it costs starting €250/year. If one needs to just draw a couple charts, it’s Think-cell that’s not cost-efficient.
@winnershandbook10699 ай бұрын
250/yr for mckinsey is nothing lol@@violentfox
@yuvrajroy12575 ай бұрын
What about π racy @@violentfox
@Daniel-tb6gn3 ай бұрын
Exactly, with Think Cell it’s a piece of cake!
@healthsis176811 ай бұрын
This is incredible! Many thanks for sharing your expertise with us!
@RedBlur081711 ай бұрын
Awesome! I’m going to copy for the dashboard I’m building at work.
@KenjiExplains11 ай бұрын
Thank you!
@PoonamShetty4138 ай бұрын
Thank you soo much Kenji you have made this excel topic easy with your explanations. Yes we want part 2 and part 3 ❣
@xllearner11 ай бұрын
Another great video! The chart is called a Stacked Column or Stacked Bar Chart.
@KenjiExplains11 ай бұрын
Thanks for the info!
@xllearner11 ай бұрын
I would also like to see a Part 2. Thank you!
@giacomobr277711 ай бұрын
One of the best videos ever! Please prepare part2
@jtb5211 ай бұрын
What's very cool is that you go for these text labels..I can spend hours assuming they can be automatically done in the chart data..not any more
@dominicgentolia92597 ай бұрын
Can't help it admiring this guy!
@gregharrison76543 ай бұрын
Firstly, I like the tutorial and the tonality + pace, all good and an excellent learning opportunity. However, these examples are for static presentations. I am using dynamic graphs in Excel that include slicers to filter results. As you've built these to replicate existing material, I see how the need is flat or static. The challenge in making these dynamic is the labelling. Any suggestions? Especially the radial bar chart, the first one. It could be a big hit if the labelling issue can be resolved.
@cashtube77711 ай бұрын
You are literally the GOAT
@s_elgebali966029 күн бұрын
thanks very much , I benefit from your video so much😍😍😍😍
@Horn_of_Afrika10 ай бұрын
More than 29k views but still 1k likes? Come on guys, let’s like & subscribe. He is teaching us freely.
@m.w.609911 ай бұрын
Great vid again! Isn’t it so that when you want to change something you don’t have to do the right click on the bar and then go to change data series but instead you just use ctrl+1 that works almost anywhere?
@nishanth432311 ай бұрын
Now that some interesting thing. .😮. can't wait for more this type of videos...🙏
@KenjiExplains11 ай бұрын
Glad you liked it! More to come hopefully :)
@VishnuVardhan-sj6nd10 ай бұрын
Did anyone recreate the Radial Chart on their MacOS ? I have the paid MS Excel version on my Macbook but I couldn't find the 'More Pie Chart' option.
@asadxo7 ай бұрын
same
@luigibru86774 ай бұрын
Excel for MacOS sucks.
@Alen_11511 ай бұрын
I like the video very much, it would help me in my scientific research papers
@waadabdullah21916 ай бұрын
Please keep making these re-creating videos.
@iainsmith227810 ай бұрын
I am assuming that the 'more charts' option is only available to windows and not mac?
@AndreMahfouz10 ай бұрын
Concerning the eyedropper tool, there's a system-wide one in the Powertoys tool developed by Microsoft, it'll save you some time.
@lr794910 ай бұрын
Can I also create all these designs on the Mac with Excel? - I can't find the pie chart (first draft) there. Many thanks in advance!
@hollowplacesblog6 ай бұрын
Thank you. This is so helpful.
@franciscaamano351911 ай бұрын
Kenji this was excellent
@mannyuruchurtu31811 ай бұрын
Bar in bar chart for the second one 👍🏽
@KManvik11 ай бұрын
Awesome...So well explained..thank you!!
@KenjiExplains11 ай бұрын
Glad it was helpful!
@weppes809011 ай бұрын
Guys, do you know why my Excel version doesn't have all the charts available ? BTW, Amazing content man ! 🙂
@KenjiExplains11 ай бұрын
it's possible that you're on an older Excel version that doesn't have all the features. In my case, I'm in Microsoft 365.
@johndavies47589 ай бұрын
I don't know if I am doing something wrong but I only get a single option for doughnut chart in Excel (M365), which is has 2 rings. I don't get the one shown on the right, which is used, with a ring for each row in the data. Anyone know how to fix this?
@growth250910 ай бұрын
Very innovative, thanks for sharing.
@camlex631011 ай бұрын
Great visuals!! Super helpful
@aneeshssundaram16752 ай бұрын
The unnamed bar chart in the second part of this exercise should be a 2-d stacked column chart
@Danny-Do-ItАй бұрын
Lets say you had this radia bar chart - if you wanted to use it every month in powerpoint, is there a way to dynamically link the text box + chart to the data in excel? meaning when i add monthly data the tables on powerpoint update with it
@laveshmalik9912Ай бұрын
For the second chart example, I also get Quarters in the bar form, how do I change that? I am doing something wrong?
@gauravmakhijani90796 ай бұрын
I’m need of this badly but need a 60% discount on the course
@gcorbalan7 ай бұрын
Thank you for sharing!
@acp48111 ай бұрын
Que versión de excel usas?, es que no me aparecen algunas opciones, como el primer gráfico saludos
@qasimbashir7033Ай бұрын
Hello there.. Chart used for radial bar chart is not showing in excel? Any help in this regard?
@ultimatefreedom69344 ай бұрын
How do you add all 3 things together - the chart, numbers and text. When increasing size of chart, text and numbers remain there.
@spikeydude11411 ай бұрын
You make awesome content. Thank you so much !
@KenjiExplains11 ай бұрын
Glad you enjoy it!
@arindambhattacharya78487 ай бұрын
For the first chart - Am sure there may be a way to avoid manually adding the percentage numbers and names and save time
@kientr99993 ай бұрын
How about the bump chart?
@yohannaagbanaji801211 ай бұрын
Great vid as usual ❤❤❤.
@rockyn31936 ай бұрын
Damn, thought you were going to show us the mekko chart in the stop left of the thumbnail
@magedx70595 ай бұрын
Awesome, thanks
@FungoTech7 ай бұрын
Great video!
@isaiahmaragalla8 ай бұрын
amazing. thank you
@UvanSankar8 ай бұрын
More pie charts unavailable in Excel. Could you tell on how to enable this?
@doritos713411 ай бұрын
Thanks for the video but I feel these are time consuming and should only be used for external presentations.
@iqbalhossain50359 ай бұрын
Thanks a lot.
@bhaveshsavla781210 ай бұрын
Query abt radial bar chart - am unable to select the helper bars to delete. In my case both the helper and percentage are being selected together. Even data series is showing them together.😢
@avinashsingh793011 ай бұрын
the Unnamed bar chart is called as thermo-meter chart
@KenjiExplains11 ай бұрын
Awesome thank you for the information!
@kameshsubramanian255310 ай бұрын
@KenjiExplains. Great video. Are any of your courses available on Udemy?
@VijaySrinivasVittalam5 ай бұрын
2nd chart is "Manhattan Towers"
@SocialReader11 ай бұрын
Part two please
@wilbalt855310 ай бұрын
Hi, do you know how to change the Data sequence in a Sunburst Diagramm? Normally its sorted by size. I'd like to sort it my myself. For example, Sales in a year: Inner circle are the quarters, outer the months. Should be Q1 to Q4 und Jan to Dec and not most Sales sorted. Thanks
@Danny-Do-ItАй бұрын
I dont have that pie chart on my list.. any idea?
@jbgood76949 ай бұрын
I'm using a MacBook Pro and I can't find the same doughnut chart that you are using in the video. I have the most current version of Microsoft 365 installed. I am not able to reduce the center of the doughnut either.
@andresqueupumilrodriguez67225 ай бұрын
mi version of excel mac don`t have the option of more circle graphs, it's s no license version
@venusflytrap90911 ай бұрын
Great doughnut chart but if the value changes the text box will not be at the end of the doughnut curve (or am I wrong ?)
@KenjiExplains11 ай бұрын
yes you're right, it would just be a bit manual there :/
@thamimalope52215 ай бұрын
powerful !
@nidaparveen155710 ай бұрын
We want part 2
@nicolasbeltranrubio636211 ай бұрын
Is there any way we can export these visuals to Excel?
@yohannaagbanaji801211 ай бұрын
Does this work on all the office versions?
@md.naimulislam391310 ай бұрын
I need part 2
@nakkulmahajan11706 ай бұрын
I can't find more charts on excel, could someone help please..
@shankarathreya18999 ай бұрын
how can we do meeko bar charts in excel?
@helloeveryone69099 ай бұрын
Can we have a a discount before the end of the year please
@Niklas-og4zm10 ай бұрын
I think the unnamed bar chart is called a bullet graph.
@faraazali95892 ай бұрын
The second chart is called a bullet chart.
@ummuhaidar8 ай бұрын
The secomd chart is called a bullet chart😊
@sawansamant16036 ай бұрын
2nd chart is bar in bar chart
@fycrtr11 ай бұрын
We use Think-cell to do our graphs, not Excel
@GODFATHER44846 ай бұрын
Why do I not have All charts
@jhadinger6 ай бұрын
It could be so easy to misrepresent data with a radial bar chart. Anyone using this needs to be aware of the story you're telling to anyone who sees your visualization. The more columns (or "rings"?) you have, the more skewed the inner and outer rings can seem. Keep this in mind! You really shouldn't use a donut chart or something resembling one unless you're showing parts of a whole.
@nguyenhuunhattan120611 ай бұрын
Nice
@KenjiExplains11 ай бұрын
Thank you
@qristomaich180911 ай бұрын
part 2?
@airforce196911 ай бұрын
It would be great if you could do this in power bi too!!!
@mariusgearip7 ай бұрын
So many manual adjustments with shapes and text boxes. If you these charts once per year, it may be bearable, but it's inefficient.
@ravbuddy26 күн бұрын
What would you suggest?
@kylebrazeal77395 ай бұрын
There's no point in making the labels dynamic as the positioning won't shift automatically....
@samuelmehinsan_11 ай бұрын
It's called stacked bar chart I guess
@samuelmehinsan_11 ай бұрын
...or not
@kanazawasyosuke226211 ай бұрын
👍
@KenjiExplains11 ай бұрын
thanks for watching!
@shivaraju859511 ай бұрын
🎉🎉🎉🎉🎉🎉🎉
@willzinner881311 ай бұрын
second
@KenjiExplains11 ай бұрын
lets go
@camg796011 ай бұрын
1st
@KenjiExplains11 ай бұрын
haha thanks for watching :)
@ericssontest23323 ай бұрын
Ggf
@Draykoh0110 ай бұрын
This donut chart isn't even dynamic. Another example of McKinsey making something pretty without being practical.