Skip to playerSkip to main content
  • 5 weeks ago
Learn how to make sleeve doughnut chart. I will also answer the question of how do I create a donut chart in Excel?
We will also answer question like, how do I make a donut chart in Excel with multiple data, and what is the difference between a pie chart and a doughnut chart in Excel?

Here, the steps outlined in my video.

Insert Doughnut Chart
1) Select cells D2 and D3
2) Insert ~ Charts ~ Insert Pie ~ Doughnut
3) Delete title and legend
4) Resize doughnut chart

Sleeve Doughnut Chart
1) Format ~ Shape Styles ~ Shape Fill ~ No Fill
2) Format ~ Shape Styles ~ Shape Outline ~ No Outline
3) Select Orange section
4) Right-click ~ Format Data Series
5) Fill & Line
6) Fill ~ Solid Fill
7) Gray
8) Select Blue section
9) Fill ~ Solid Fill
10) Green
11) Border
12) Solid Line
13) Color to Green
14) Width to 8pt

How do I create a donut chart in Excel?,What is the use of donut chart in Excel?,How do I make a donut chart in Excel with multiple data?,What is the difference between a pie chart and a doughnut chart in Excel?,

Transcript
00:00If you want to create a sleeve donut chart looking like this, this is how you do it.
00:04Select cell D2 and D3 like this. Go to insert under chart. There's this pie chart here. Click
00:09on donut. Then after that, get rid of the chart title, legend, and resize it nicely so that it
00:14fits on your screen. Next, you're going to go to format, shape style, shape feel. You're going to
00:20remove the feel from it and go to shape outline and remove the outline like this. After that,
00:25you're going to right click on the orange section, format data series. In here, you're going to select
00:29fill and line. After that, you're going to say solid fill and we're going to select a gray color,
00:34something like that. After that, click on the blue fill here or the blue section of the pie chart.
00:41Then in here, we're going to select a green color like this. On the border here, we're going to change
00:46this to green as well and basically change the width of this to be eight points and hit enter
00:52and close this format data point here. Now it looks like a sleeve donut.
Be the first to comment
Add your comment

Recommended