Data Visualization Power Move: Nested Pie Charts in Excel

preview_player
Показать описание
Data Visualization Power Move: Nested Pie Charts in Excel
Learn to make a nested pie chart - also called a pie in pie chart in Excel. This allows you to show two different data sets in one chart in Excel. These pie graphs are pretty easy to create and I'll show you exactly how to make one using your own data.

IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
Techniques to Shrink Text to Fit on Fewer Pages in Microsoft Word

#helenbradley #microsoftexcel #microsoftoffice #projectwoman #Excelforstudents #excelforbeginners #excelformulaforjobinterview
Рекомендации по теме
Комментарии
Автор

Brilliant! Wanted to do a chart like this for ages but never knew how to get it done in excel. Great Video, clear and concise instructions, no unnecessary frills, straight to the point. Love it!

Lady_Gilraen
Автор

I love how clearly you speak
Nice video too

josephfatoye
Автор

great video, very easy to follow - thank you!

carok
Автор

Hi, this video has been super useful. I just have a format question, is it possible to reduce the width of the outer layer of the chart?

karlahernandez
Автор

How do you get the 2020-2022 outer ring data to match up with the inner ring data? I.e. how did the outer ring for 2022 know to use three data points for the inner ring versus the 2020 and 2021 only having two data points? Thank you very much for the video!

BrandonKlee-jc
Автор

This is a really neat visual; thanks for the tutorial! Just a curiosity question, is there a reason you start as a donut and not a pie chart? One of the first things you do at 1:16 is essentially turn it into a pie chart. I’m guessing you don’t have the overlay option with a pie chart? Just curious, thanks!

christinwoodrow
Автор

Thanks a lot. It is very very informative and useful yo me as it is completely unknown to me.

biswajitkaran
Автор

Hi, I tried to replicate this. It is so cool! But when it comes to the step to format labels of the 2nd serie the "value from cells" option does not show up. Is there any workaround?

macshock