5 Impressive Visuals You Didn't Know Excel Could Do

preview_player
Показать описание
Make 5 awesome advanced excel charts and visuals to impress anyone!

In this video you'll learn to make 5 awesome advanced excel visuals to impress anyone. First we'll make a waffle chart in Excel, where you can see the capacity out of the total. Then we'll make a line chart with markers, with some shapes to emphasize a general trend. Third, we'll make a radar chart to show how a restaurant is performing out of 100% in different metrics. Fourth, we'll make a variance charts to see the percentage change month over month. Finally, in fifth, we'll create a dumbbell chart which combines a scatter plot and lines.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Chart 1
3:21​ - Chart 2
5:50​ - Chart 3
8:31​ - Chart 4
11:23​ - Chart 5
Рекомендации по теме
Комментарии
Автор

You are a true genius! Your videos have been extremely helpful. Thank you very much.

LAMchannel
Автор

Great collection and awesome explanation! Thank you for the video!

howtolearnexcel
Автор

Really informative video!! Thanks Kenji

camlex
Автор

Thank you kenji, I am still on the line chart part of the video and I just remembered, Is there a video on combo charts that have the same x axis but different y axes? I am a geodetic engineering student and I want a video on such a chart for my mass haul and formation level chart. Thank you

kannorambrose
Автор

Thank you for sharing your knowledge in such an easy-to-understand way! Your videos have been incredibly helpful. I really appreciate it Subscribe - Kenji

AsiyaSolanki-fl
Автор

hello !

great video!

How do I enable this + sign for my chart?

alexbeniniteixeira
Автор

Kenji, what is the formula I can use to replace SORT and SEQUENCE (I am using Excel 2016 at the moment). The video was AWESOME!!!

oluwandetowoju
Автор

Please create more videos of power BI to send to your channel

swapnilgokhale
Автор

thanks! Is there a way to do the waffle chart in another shape? Like lines instead of squares?

willzinner
Автор

Will I be able to connect it to a slicer??

sass
Автор

Please create the course of Power BI and MySQL for me. I would like to become a business analyst

swapnilgokhale
Автор

In second chart after doing all things my chart not coming front.."bring to front" function is disabled..pls provide solution

chiragdabhi
Автор

I have data let's say only with starting number for example abc001 to abc009 I want all the number in transpose format any help?

sudarshanshetty
Автор

Hello Sir, I need your help.
I want a formula that if
• if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated
• If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated
• if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated

Please Reply Sir

kameshsharma
Автор

In the Second Line & Market Chart tutorial whenever, I click on the bring it to the front only the line chart appears and the text box doesn't show. Can you please help.

arsalanahmad
Автор

That is great 😊 I have learned some tips to apply to my work. Thank you so much

hado-hado
Автор

Average age to own a house chart dataset is really depressing..

charismafunds