3D Donut Chart in Excel - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Learn how to make 3D donut chart in Excel.  To create a 3D donut chart in Excel, first, select your data and go to the Insert tab, then choose the Pie Chart option. Next, click on the 3D Pie Chart icon and select the donut chart style. Alternatively, you can find the 3D pie chart under the Insert tab in the Charts section. Excel does indeed support 3D charts, including donut charts. Additionally, you can insert 3D models into Excel by clicking on the Insert tab, then choosing 3D Models and selecting the desired file. As for using 3D functions in Excel, they are available under the Formulas tab, where you can explore various functions for 3D calculations and data manipulation.  After this video, you will be able to answer the following question. How do you make a 3D donut chart in Excel? Where is the 3D pie chart in Excel? How to make a 3D donut chart? Can Excel do 3D Charts? How do you insert 3D Models in Excel? How do you use 3D functions in Excel?  Here are the steps outlined in my video.  Have you ever wonder if 3D doughnut chart is possible in Excel? Yes you can. Let me show you how.  Insert Doughnut 1) Insert ~ Illustrations ~ Shapes 2) Basic Shapes ~ Circle - Hollow 3) Hold Shift and drag release left mouse  Convert to 3D Shape 1) Right-click on doughnut 2) Format shape... 3) Fill & Line    Fill color = Green    Line = None 4) Effect 6) 3-D Format 7) Top bevel to Round    Width: 42 pt    Height: 42 pt 8) 3-D Rotation    X Rotation: 340    Y Rotation: 328    Z Rotation: 33  Ratio Pie 1) Select dataset 2) Insert ~ 2-D Pie ~ Pie 3) Remove Chart title. 4) Remove Chart legend  Overlay Ratio Pie 1) Resize the pie chart so that is it is larger than the 3d doughnut 2) Select both 3d doughnut and pie chart 3) Shape Format ~ Arrange ~ Align ~ Align Center 4) Shape Format ~ Arrange ~ Align ~ Align Middle  Bring Together 1) Right-click ~ Format Chart Area... 2) Fill & Line    Fill color = No fill    Border = No line 3) Select pie chart    Border = No line 4) Select blue pie    Fill color = No fill 5) Select last pipe chart    Fill color to white    Transparency to 20%     How do you make a 3D donut chart in Excel?,Where is the 3D pie chart in Excel?,How to make a 3D donut chart?,Can Excel do 3D Charts?,How do you insert 3D Models in Excel?,How do you use 3D functions in Excel?,   Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@jjnet247/shorts https://www.tiktok.com/@exceltips247 https://www.instagram.com/exceltips247/ https://www.dailymotion.com/ExcelTips247 https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/ https://x.com/ExcelTips247/media https://www.reddit.com/r/Excel247/ https://www.facebook.com/XyberneticsInc/reels/  #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00Have you ever wondered if a 3D doughnut chart is even possible to be created in Excel?

00:05Yes, you can. Let me show you how you can do this.

00:08First, you're going to go to Insert from a Ribbon, Illustration Shape.

00:11Under the Basic Shape section, click on Circle Hollow,

00:15and then hold down your Shift on the keyboard and drag while holding your left mouse button.

00:20It will create a perfect circle with a hollow in it.

00:22Next, you're going to convert that to 3D shape.

00:25Right-click on your doughnut, Format Shape.

00:27Under Field and Line, you select the color that you want for your field color,

00:31and for Line, you're going to say None.

00:33Under Effects, 3D Format.

00:35On the top bevel, you're going to select Round,

00:37and the Width, I'm going to say it's about 42, and the height's going to be 42 as well.

00:42Change this number accordingly so that it looks like a doughnut.

00:45Under 3D Rotation, my X Rotation is going to be 340 degrees,

00:48Y Rotation is going to be 328,

00:51and my Z Rotation is going to be 33 degrees.

00:54Next, to Insert the Pie Chart, select your data set.

00:57Insert 2D Pie and Pie.

00:59Remove the chart title and the legend.

01:01Now, to overlay the pie chart on the 3D doughnut,

01:04resize the pie chart so that it is larger than the 3D doughnut.

01:08Then select both 3D doughnut and the pie chart.

01:11Then go to Shape, Format, Arrange, Align, Align Center, and Align to Middle.

01:16And now, to bring everything together,

01:18right-click on your chart, Format Chart Area.

01:21Under the Fill and Line, you're going to say Fill Color as No Fill,

01:24Border as No Line.

01:26Now, select the pie chart on the border.

01:28You're going to say No Line.

01:29And select the blue pie chart now and say Fill Color to No Fill.

01:33And select the last pie chart here, like this one.

01:36And then the fill color should be set to white

01:38and the transparency to 20%.

01:40And then you're done.

01:42And then you're done.

3D Donut Chart in Excel - Excel Tips and Tricks

Category

Transcript

Comments

Recommended