Create a Doughnut Chart
HTML-код
- Опубликовано: 21 авг 2024
- A doughnut chart is similar to pie chart in that it's round, but that where most of the similarities stop. Doughnut charts have the added benefit of providing more space for data to show relationships between things. Like many other Excel charts, there are different ways to show the data in a doughnut chart, so check out this video to learn 4 ways. There are 4 examples 1st (2:00), 2nd (4:25), 3rd (8:35), 4rth (13:35)
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
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. : )
Hi EnigmaticRPG, thanks for the comment!
One more amazing lesson creates a attraction wizard to reporting job nowadays! Thanks Doug H.
Good job done.
Hi Stephen Phan, glad you liked it, thanks for commenting!
Very well explain for a newcomer to understand.
Thankyou.
Very helpful.
Glad it was helpful!
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)
Glad it helped!
Thanks!
Welcome! Thanks for the support!
IT helped me tremendously & made it so easy for me to follow & replicate !! THANKS !
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!
Thank you for the tips!!!!
You’re welcome!
You are brilliant. Thanks for uploading. If possible, upload some more innovative chart
it helped me a lot :) thank you !!!
Glad it helped!
Very Nice......Thank you ......Superb video!!!!
Your voice sounds soothing. I like you.
Hi Chameleon King, thanks for the kind words!
Helped me a lot!!
Thanks Hadas Doron, glad it helped!
Great Time Hyperlinks!
I love it!! I have been using that feature for a few years. It really helps viewers a lot!
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/RUclips created! As a user, I love it because I can come back later and click back to the exact place that I want!
Awesome. .
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
When you click on the label and right click "Format Data Label" it should give option to add leader lines
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.
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
Phone mein ise konsa app se kr skte hai plz help
doug h shows doug h nut charts. i'm going to pronounce it like that from now on, in honor of this video
Awesome
How does that great time hyperlinks work.???
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.
Hi Barbra, try a post on the mrexcel.com forum!
In your 4th example; how do you put the circle in? Your explanation is a bit lacking there.
Goto Insert>Shape and select the oval icon. Press the shift key while drawing out the shape to get the circle.
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
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.
@ thanks! it is similar yes. Regards
@
Just trying to make donut chart but can't get 3d option in chart tools, please help.
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.