Doughnut Pie Chart in Excel - Infographic

  Рет қаралды 257,388

Haider Niaz

Haider Niaz

3 жыл бұрын

Multi doughnut graphs are an exciting and creative way to present your data. They give a completely new perspective to your data and present beautifully.
This tutorial contains the excel and PowerPoint files for your reference.
Google drive link for Excel sheet:
docs.google.com/spreadsheets/...
Google drive link for PowerPoint sheet:
docs.google.com/presentation/...
📃 Watch related playlists and videos:
• How to make an academi...
🚩 Connect with me on social:
- LinkedIn: / haider-niaz-80690378
- Facebook: / haider.niaz.20
If you need design-related Help, Contact me at: haiderniaz12@gmail.com
If you don't want to learn for Free, Pay me to get your work done on Fiver :D : www.fiverr.com/share/LvLke0
🔔 Subscribe to my KZbin channel:
/ haiderniaz
#Excel #powerPoint #Graph

Пікірлер: 83
@meimeimeow2160
@meimeimeow2160 Жыл бұрын
The chart is just gorgeous!!! Very clearly explained. Thank you so much!!!
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks :)
@elishmuel1976
@elishmuel1976 2 жыл бұрын
This was incredibly useful. Exactly what I was looking for to better present my data edit: you are the GOAT for coming back to explain the how to change the % values in the graph. thanks!
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Happy to hear that :)
@Idgafabouturopinion
@Idgafabouturopinion 2 жыл бұрын
There is a better way to do this: Go to Chart Design --> Select data source --> and instead of just create one series for your doughnut chart, create three series, and select the corresponding data of the series in the "Y-values" tab. After that, change the colour of the unnecessary slices in the second and third ring to white / simply no fill. This will save you lots of time. Hope more people will see this. I do like the concept of the chart though.
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Thanks thats a very nice tip. Will use this in upcoming videos. Thanks for stopping by the video :)
@katrinesofialind649
@katrinesofialind649 2 жыл бұрын
This was a massive help to make a professional looking chart, thank you!
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
My pleasure 😊
@exnihilog.4421
@exnihilog.4421 9 ай бұрын
beautiful clean chart exactly what I was looking for !!! thank you!
@HaiderNiaz
@HaiderNiaz 9 ай бұрын
Thanks :)
@ImranAli-pc4mp
@ImranAli-pc4mp 3 жыл бұрын
Thanks for this one, i was searching for this and you uploaded just in right time
@HaiderNiaz
@HaiderNiaz 3 жыл бұрын
Oh thats great :) thanks Imran bro :) Let me know if you need help :)
@ImranAli-pc4mp
@ImranAli-pc4mp 3 жыл бұрын
@@HaiderNiaz yeah sure , thanks :)
@sundeshbalraj
@sundeshbalraj Жыл бұрын
Brilliant work - helped me so much !
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Glad it helped!
@momotaro0410
@momotaro0410 Жыл бұрын
I cant stop myself from giving u a like and comment. Thats awesome
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks :)
@asifmahmoodliaquat5866
@asifmahmoodliaquat5866 2 жыл бұрын
very well demonstrated. thanks for sharing. plz keep good work up.
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Thanks glad to hear that :)
@maryamsarfraz5522
@maryamsarfraz5522 3 жыл бұрын
Jazak Allah Kher (y) Much Obliged for your efforts
@HaiderNiaz
@HaiderNiaz 3 жыл бұрын
My pleasure 😊
@MaggieFort
@MaggieFort 5 ай бұрын
this was awesome, thank you!
@HaiderNiaz
@HaiderNiaz 5 ай бұрын
My pleaure :)
@Digital-Light
@Digital-Light 11 ай бұрын
very good tut , thanks!
@HaiderNiaz
@HaiderNiaz 10 ай бұрын
Glad it helped!
@HarikaMaruboyina1
@HarikaMaruboyina1 Ай бұрын
This is super cool and helpful! So easy to replicate too! Thanks a ton for this!
@HaiderNiaz
@HaiderNiaz Ай бұрын
Happy to hear that :)
@oriweiss32
@oriweiss32 2 жыл бұрын
Excellent video, helped me a lot.
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Thanks 😊
@AA-rd3xi
@AA-rd3xi Жыл бұрын
👍👍👍 great job
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks 👍
@khantalks0
@khantalks0 2 жыл бұрын
Just amazing bro
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Thank you :)
@karlahernandez6895
@karlahernandez6895 4 ай бұрын
Very helpful...it gave me a better idea to do a pie in pie chart similar to this. Thanks!
@HaiderNiaz
@HaiderNiaz 4 ай бұрын
Happy to hear that :)
@m87eyz
@m87eyz Жыл бұрын
So informative, jazakALLAH
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks :)
@dziggy983
@dziggy983 6 ай бұрын
Realy nice video. Thanks bro 👍
@HaiderNiaz
@HaiderNiaz 6 ай бұрын
Thanks
@Muhammad_Asim_Piano
@Muhammad_Asim_Piano 2 жыл бұрын
Brilliant… thanks
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
My pleasure :)
@panizzarghami106
@panizzarghami106 Жыл бұрын
THANKS IT WAS PERFECT
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Happy to hear 😊
@gabyflores9412
@gabyflores9412 2 жыл бұрын
Nice!
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Thanks 😊
@nadiahussain1791
@nadiahussain1791 5 ай бұрын
Really great 👍
@HaiderNiaz
@HaiderNiaz 5 ай бұрын
Thanks :)
@desalegndaniel68
@desalegndaniel68 Жыл бұрын
nice explanation
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks
@user-mz6rn3sw7x
@user-mz6rn3sw7x 4 ай бұрын
thankyou for sharing
@HaiderNiaz
@HaiderNiaz 4 ай бұрын
Happy to do so.
@haopinandy
@haopinandy Жыл бұрын
amazing sharing!!! thank you!! but if the resolution can be improved that will be great!!!
@HaiderNiaz
@HaiderNiaz Жыл бұрын
There is another video in my channel, that will be helpful.
@shaheenaldashti6558
@shaheenaldashti6558 8 ай бұрын
Thank you so much I have one question , how did you combine all the pie charts in the powerpoint at the end of the video and copied it into another slide as one piechart , thank you again
@HaiderNiaz
@HaiderNiaz 7 ай бұрын
Just group them, and paste them special in any format you want
@sunnylin2584
@sunnylin2584 2 жыл бұрын
How to delete outline when we combine charts? I tried "Shape Outline > No Outline" but NOT successful. Thanks in advance for the advices
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Try doing that individually. It might help. Or try selecting white color instead or no color.
@a4kata655
@a4kata655 2 жыл бұрын
Thanks
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
My pleasure, if you have any problems, feel free to ask.
@umairkhan8020
@umairkhan8020 2 ай бұрын
Brother, The Chart is a phenomenal Idea. But May I suggest an approach that would significantly reduce your "Adjustment/Alignment" of secondaray and territory doighnut charts. Select the 2nd Doughnet chart, Copy and Pase it in the First One after selecting the first one, do the same for the 3rd one, This will automatically adjust the 2nd and 3rd chart around the centre,
@HaiderNiaz
@HaiderNiaz 2 ай бұрын
Thanks for sharing. Ill try this.
@excel168
@excel168 10 ай бұрын
Nice lesson. I plan to create content same u to help people who keen to learn new things.thanks
@HaiderNiaz
@HaiderNiaz 10 ай бұрын
Thabls, good luck :)
@dhegiikrapriandana9790
@dhegiikrapriandana9790 2 жыл бұрын
Hello, i have box the outside each chart when i copy them to powerpoint. how to fix?
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Just select it, go to format options, and remove outline to no outline
@dhegiikrapriandana9790
@dhegiikrapriandana9790 2 жыл бұрын
@@HaiderNiaz thank you sir
@irinanix9647
@irinanix9647 Жыл бұрын
What font did you use for section on the right?
@HaiderNiaz
@HaiderNiaz Жыл бұрын
I dont recall it, maybe century Gothic or Calibri.
@irinanix9647
@irinanix9647 Жыл бұрын
@@HaiderNiaz thank you for this tutorial, it’s been very helpful!
@HaiderNiaz
@HaiderNiaz Жыл бұрын
@@irinanix9647 my pleasure :)
@foodstorybylk4608
@foodstorybylk4608 7 ай бұрын
@HaiderNiaz
@HaiderNiaz 7 ай бұрын
Thanks
@yohovisa
@yohovisa 2 жыл бұрын
how to get the prepared pantone colour ahead in your video
@HaiderNiaz
@HaiderNiaz 2 жыл бұрын
Do you mean the color palette? You can find color palettes from multiple websites. Just look for website named coolrs. They have a lot of variants. If you need anything else let me know
@asmitagaykar757
@asmitagaykar757 2 ай бұрын
Can qe make same visual in power bi
@HaiderNiaz
@HaiderNiaz 2 ай бұрын
Sure, Ill try.
@Souvikblogs
@Souvikblogs Жыл бұрын
if i want 2 or more sectional brekup then it is not helpful but thanks for sharing..
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Yeah then Ill recommend you to use OriginPro. My pleasure :)
@keita1029
@keita1029 29 күн бұрын
Good technique but really bad explanation as you go back and forth about what actually you do not have to show. I will recommend you to try more effort on video creation by cutting unnecessary parts.
@HaiderNiaz
@HaiderNiaz 29 күн бұрын
I make it in a single go, just sharing what I know, so I dont have to spend enough time editing it. Thanks
@MJLCabral
@MJLCabral Жыл бұрын
Excellent tutorial, you said you explained how to do it and where to get the color palette, but you forgot
@HaiderNiaz
@HaiderNiaz Жыл бұрын
Thanks for the compliment. I am sorry for that. You can check the palettes on coolrs.com
Advanced Pies And Doughnuts Charts In Excel
11:53
Mellon Training
Рет қаралды 1,4 М.
Infographics: Progress Circle Chart in Excel
12:29
PK: An Excel Expert
Рет қаралды 1,1 МЛН
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 377 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 272 М.
Create Pie Chart easily in PowerPoint. Tutorial No. 883
8:01
POWERPOINT UNIVERSITY
Рет қаралды 77 М.
Multilayered Doughnut Chart : Part-1
14:11
PK: An Excel Expert
Рет қаралды 35 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 201 М.
Make Beautiful 3D Pie charts in PowerPoint | Step by step tutorial
16:28
Slides and Cells
Рет қаралды 69 М.