Create a Doughnut Chart

[@EnigmaticRPG]

Still useful in 2021! Thank you so much for this! I'm using OpenOffice Calc and didn't realize this was in Excel since the steps are nearly identical. : )

[@DougHExcel]

Hi EnigmaticRPG, thanks for the comment!

[@goleshekhar]

Very well explain for a newcomer to understand. Thankyou. Very helpful.

[@DougHExcel]

Glad it was helpful!

[@stephenphan2761]

One more amazing lesson creates a attraction wizard to reporting job nowadays! Thanks Doug H. Good job done.

[@DougHExcel]

Hi Stephen Phan, glad you liked it, thanks for commenting!

[@EllaBella-gm1dv]

13:35 very useful. Ctrl 1 for formatting chart. F4 to repeat last action with the colors. To make circle and not oval press shift key (didn't know this)

[@DougHExcel]

Glad it helped!

[@bryonlim3183]

Thanks!

[@DougHExcel]

Welcome! Thanks for the support!

[@bronwynnengelbrecht511]

IT helped me tremendously & made it so easy for me to follow & replicate !! THANKS !

[@SHEL_ife.]

Thank you for the tips!!!!

[@DougHExcel]

You’re welcome!

[@abrahamlincoln9341]

You are brilliant. Thanks for uploading. If possible, upload some more innovative chart

[@JaceCheong1119]

Version 2013 allows us to select "Show Leader Lines" in the Label Options, so there is no need to manually perform Example 3 anymore. However, that's a good idea to form a circle in the middle of doughnut in Example 4, set CEO to 360 in Series 1!

[@axxieee]

it helped me a lot :) thank you !!!

[@DougHExcel]

Glad it helped!

[@AbdulKareemAbdulRahman]

how do we add leader lines to either or both the inner or outer rings in the 4th donut model? (as distinct from your third model that only has one ring) thank you

[@DougHExcel]

When you click on the label and right click "Format Data Label" it should give option to add leader lines

[@uniquegaming2485]

Phone mein ise konsa app se kr skte hai plz help

[@vijaymore1239]

Very Nice......Thank you ......Superb video!!!!

[@chameleonking2449]

Your voice sounds soothing. I like you.

[@DougHExcel]

Hi Chameleon King, thanks for the kind words!

[@excelisfun]

Great Time Hyperlinks!

[@excelisfun]

I love it!! I have been using that feature for a few years. It really helps viewers a lot!

[@excelisfun]

You are one of the only other Excel guy that I have seen that uses it. It is just a REALLY awesome thing that Google/KZbin created! As a user, I love it because I can come back later and click back to the exact place that I want!

[@mistypearson8865]

I can not get this to work beyond 2 doughnuts. Any suggestions? My third and fourth layer only have numbers that do not make any sense. I can not get the tables to work at all.

[@DougHExcel]

Ensure that your blank cells don't have any values in them and also try to add the series of data in one by one. HTH

[@hadasneuman8102]

Helped me a lot!!

[@DougHExcel]

Thanks Hadas Doron, glad it helped!

[@ameydabholkar97]

How does that great time hyperlinks work.???

[@barbra429]

Can someone please tell me how to change the size of the "slices"'...I am a beginner and the slices are too tall with too much empty space in them. Thanks. Btw, I have MS Excel 2007.

[@DougHExcel]

Hi Barbra, try a post on the mrexcel.com forum!

[@sapisoftware1942]

Min 18:46 does somebody know how I get these chart styles? I have Excel 2019 and I dont see these styles

Doble Click in the object. Then go to 3D Format. And Select any type of 3D Besel. I hope it helps. I have my office in spanish so it think the names will be little similar.

[@sapisoftware1942]

@ thanks! it is similar yes. Regards

[@goleshekhar]

@ Just trying to make donut chart but can't get 3d option in chart tools, please help.

[@DougHExcel]

Hi Sapi Software, thanks for the comment! Try clicking the graph and then go to the Chart Styles group. It's different now because the color option and the style have been separated.

[@AlthafHussainalthafonline]

Awesome. .

[@AlthafHussainalthafonline]

Awesome

[@NoSuchThingAsLuck]

In your 4th example; how do you put the circle in? Your explanation is a bit lacking there.

[@DougHExcel]

Goto Insert>Shape and select the oval icon. Press the shift key while drawing out the shape to get the circle.

[@reesewilson]

doug h shows doug h nut charts. i'm going to pronounce it like that from now on, in honor of this video

[@kurtzahner]

How do I create a regular-looking pie chart with a donut chart directly around the perimeter? Like this: si.wsj.net/public/resources/images/BN-MV467_0229ah_P_20160229152206.jpg