Data Visualization Power Move: Nested Pie Charts in Excel

  Рет қаралды 37,117

Microsoft Office

Microsoft Office

Жыл бұрын

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.
TIP ME TO SAY THANK YOU? ► paypal.me/projectwoman
IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
A Microsoft Word Macro to Resize All Images in a document • A Word Macro to Resize...
Excel - Chart With 2 Axes - Add a 2nd Axis to a Chart & Control the Data Shown ► • Excel - Chart With 2 A...
Excel - Charts that Don't Lie - Configure Sparklines to be Useful ► • Excel - Charts that Do...
Excel - Conditional Format Shade Alternate Rows - Create a Quick & Easy Format► • Unbelievable Excel Sec...
Excel - File Save Macro - A Smart Macro to Manage Saving Files Better ► • Excel - File Save Macr...
Excel - Macro to Shade Alternate Rows in a Selection► • Excel - Macro to Shade...
Excel - Personal Macro Workbook - what it is and how to create and use it ► • Excel - Personal Macro...
Excel - Save to Computer not OneDrive - Change the Excel default Save location ► • Excel - Save to Comput...
Excel - VBA File Open Macro - Make & Add to Ribbon for One Click Access► • Excel - VBA File Open ...
Excel Chart for B & W Print & Photocopying - Grayscale Chart Formatting ► • Excel Chart for B & W ...
Excel Data With ChatGPT - Create Data for Practice - for Teachers & Trainers► • Excel Data With ChatGP...
Excel Goal Seek - Find Answers Quickly & Easily ► • Excel Goal Seek - Find...
Excel NETWORKDAYS.INTL: Unlock the Secrets to Accurate Workday Count► • Excel - Count Workdays...
Excel Splash Screen - Display with a Macro on Opening a File ► • Excel Splash Screen Ma...
Microsoft Excel - Click to Enter Data - Create Custom Spin Buttons ► • Excel - Click to Enter...
Microsoft Excel - Count days between two dates ► • Excel - Count days bet...
Microsoft Excel - Custom Lists and Sort lists ► • Excel - Custom Lists a...
Microsoft Excel - Format a List Instantly - Quick & Easy Table Formatting Trick for Lists ► • Insanely Simple Excel ...
Microsoft Excel - Hide Unused Rows and Columns - Show only used cells ► • Excel - Hide Unused Ro...
Microsoft Excel Mac - Remove Custom Templates ► • Excel Mac - Remove Te...
Microsoft Word - Change Default Image Wrap ► • Word - Change Image De...
Microsoft Word - Images in Tables - How to place & position pictures in Word Tables ► • Word - Images in Table...
Microsoft Word - Table Cell Widths - Adjust one or more with ease ► • Microsoft Word - Table...
MS Word - Create a Printable Checklist - Quick & Easy for Beginners - Saleable checklists ► • MS Word - Create a Pri...
Office Tab for Word Excel and PowerPoint - A quick look at this handy application ► • Office Tab for Word Ex...
Save Time in Excel: Quick Math Operations with Copy-Paste - Apply Math Operation to all Data► • Save Time in Excel: Qu...
Special Characters On Word QAT - A Macro to Insert Symbols with One Click ► • One Click Special Char...
Word - Clickable Checkbox Macro - Insert a handy checkbox into any document ► • Word - Clickable Check...
Word 365 - 4 Rotate Text Methods - Angled Vertical & Flipped ► • MS Word - Rotate Text ...
Word Calendar Wizard - Get the original Calendar Wizard to work in 2023 ► • Word Calendar Wizard -...
Loan Math: Excel Calculations Made Easy ► • Calculate Loan Repayme...
Excel Printable Watermark - Only Uses Excel, Customizable & Easy to Make ► • Watermark a Worksheet ...
Excel: Control What You See with Views - Quick & Easy Screen Customization ► • Excel: Control What Yo...
MS Word Image Inside Shape - Place, Scale and Move ► • MS Word - Crop an Imag...
Excel Set up & Use Constants in Worksheets ► • Excel Set up & Use Con...
You're Doing it Wrong - Excel is NOT a Calculator ► • Excel Mistake You’re M...
Excel Gauge Chart - Updates Automatically ► • Make a Dynamic Gauge C...
Absolute or Relative? Navigate Cell Addressing in Excel ► • Absolute or Relative? ...
The Art of Adding Text to Numbers in Excel ► • Add Text to Numbers in...
What to do when Excel Averages Go Wrong - Understand & Fix the Problems ► • When Excel Averages Go...
The Danger of Using Numbers for Column Headings in Excel ► • Danger: Don’t Use Numb...
Chart like an Excel Pro & Avoid Rookie Mistakes ► • Excel Chart Basics tha...
Excel Chart Customizing 101: Smart Excel Tips for Beginners ► • Excel Chart Customizin...
Techniques to Shrink Text to Fit on Fewer Pages in Microsoft Word
► • Video
Mastering Excel Headers and Footers: A Beginner's Guide ► • Master Excel Headers &...
Simple Excel Macro to Change Fonts in Sheets and Charts ► • Simple Excel Macro to ...
#helenbradley #microsoftexcel #microsoftoffice #projectwoman #Excelforstudents #excelforbeginners #excelformulaforjobinterview

Пікірлер: 19
@carok6673
@carok6673 6 ай бұрын
great video, very easy to follow - thank you!
@MasterMicrosoftOffice
@MasterMicrosoftOffice 6 ай бұрын
You are welcome!
@josephfatoye6293
@josephfatoye6293 4 ай бұрын
I love how clearly you speak Nice video too
@MasterMicrosoftOffice
@MasterMicrosoftOffice 4 ай бұрын
So nice of you to say that 😊
@dharanendrad
@dharanendrad 3 ай бұрын
Nice and clear video, Thank you
@MasterMicrosoftOffice
@MasterMicrosoftOffice 3 ай бұрын
Glad it was helpful!
@LosoIAm
@LosoIAm 5 ай бұрын
Thank you very much!
@MasterMicrosoftOffice
@MasterMicrosoftOffice 5 ай бұрын
You're welcome!
@christinwoodrow9297
@christinwoodrow9297 10 ай бұрын
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!
@MasterMicrosoftOffice
@MasterMicrosoftOffice 9 ай бұрын
Great question, yes there is a reason to use a donut chart. A pie chart can't be 'stacked on itself' where as a donut chart can so you can't achieve this same effect with a donut chart.
@biswajitkaran89
@biswajitkaran89 Ай бұрын
Thanks a lot. It is very very informative and useful yo me as it is completely unknown to me.
@MasterMicrosoftOffice
@MasterMicrosoftOffice Ай бұрын
Glad to hear that
@karlahernandez6895
@karlahernandez6895 5 ай бұрын
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?
@MasterMicrosoftOffice
@MasterMicrosoftOffice 4 ай бұрын
Unfortunately not. I had a look for you and there is no way to adjust the width of the outer layer. Sorry about that.
@karlahernandez6895
@karlahernandez6895 4 ай бұрын
Thanks for checking 😊
@MasterMicrosoftOffice
@MasterMicrosoftOffice 4 ай бұрын
My pleasure.
@macshock632
@macshock632 5 ай бұрын
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?
@macshock632
@macshock632 5 ай бұрын
Sorry, resolved, I had a old version of Excel. Thanks for the video.
@MasterMicrosoftOffice
@MasterMicrosoftOffice 5 ай бұрын
Thank you so much for letting me know. Finding more information about this for you was on my To Do List for Monday. I am so glad you found the solution.
Pro-Level Excel Charts: Customize Y-Axis Labels with Colors
5:51
Microsoft Office
Рет қаралды 6 М.
Advanced Pies And Doughnuts Charts In Excel
11:53
Mellon Training
Рет қаралды 1,7 М.
ОБЯЗАТЕЛЬНО СОВЕРШАЙТЕ ДОБРО!❤❤❤
00:45
Chapitosiki
Рет қаралды 4,9 МЛН
Useful gadget for styling hair 🤩💖 #gadgets #hairstyle
00:20
FLIP FLOP Hacks
Рет қаралды 10 МЛН
Little girl's dream of a giant teddy bear is about to come true #shorts
00:32
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 393 М.
Doughnut Pie Chart in Excel - Infographic
19:11
Haider Niaz
Рет қаралды 262 М.
Create a Pie of Pie Chart to Show Details Within a Data Value
4:43
Six Minutes. Smarter.
Рет қаралды 70 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 474 М.
Sunburst Charts in Excel - Everything you need to know
4:15
Big Excel Energy
Рет қаралды 10 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 283 М.
Progress Circle Chart in Excel as NEVER seen before!
10:31
Leila Gharani
Рет қаралды 667 М.
How to Make a Pie Chart in Excel
13:31
Kevin Stratvert
Рет қаралды 393 М.