Today’s video tutorial offers a quick and easy way how to create a simple doughnut chart in Excel, through which you can make a clear visual representation of data.
So, let’s have a look at how to do that!
First step to create a doughnut chart in Excel is to select data to be represented in the chart. Here we want to include only the data for the first quarter. So, we select only the data for January, February, and March.
Once selected, click on the Insert tab and in the section ‘Charts’, click on ‘Insert Pie or Doughnut Chart’.
Right at the bottom, we find the option ‘Doughnut Chart’, so we click on it and here we go – a doughnut chart inserted instantly within the spreadsheet.
Let’s have a look now at a couple of options we can use to make the doughnut chart better according to what we need.
We can easily adjust the position of the chart in the spreadsheet. Just stay within the blank area of the chart, double click and hold the left mouse button, and drag the whole chart wherever you need.
The same works with the size of the chart – simply double click and hold the left mouse button on one of the little circles located in the corners of the chart area and by dragging adjust the size as needed.
And let’s move on now.
Click on ‘Chart Title’ to change its name based on what data the chart represents.
But that’s not all.
It’s simple to pick a colour scheme or a style for the chart if needed, too. Again, click into the blank space of the chart area.
This opens the ‘Chart Design’ tab with even more options and find ‘Change Colors’.
Here you can choose from various palettes of colours the one you like best. We’ll go for this one.
We can also pick from a range of chart style designs. Again, up here in ‘Chart Design’ we find ‘Chart Styles’.
Click on the arrow down and choose the style that suits us best. Let’s use this one.
And before we wrap it up today, there’s one thing to remember.
The chart is dynamic, which means that if we change a value in the data table, the change will be reflected in the chart immediately. So, if we change the sales for February from 125 to let’s say 53, the chart shows the current value right away.
If you’d like to know how to easily create other chart types or how to modify them further, watch separate video tutorials by EasyClick Academy. The links to the videos are in the description below.
Don’t miss out a great opportunity to learn:
If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!
Thanks for watching and I’ll see you in the next tutorial!