Excel doughnut chart templates

When clicking on the Format Data series, a format menu appears on the right side. Now to input, the percentage text selects the Doughnut Then click on Shapes under Illustrations option from Insert menu and select Rectangle box. Now give the formula to represent the status of the project. Now we should format that text. Right-click on the text and select the format. Select the Fill and select No Fill, then the blue color will disappear. Now apply a format to the text as per your doughnut color for that particular field.

Select the text and right-click from the pop-up, select the formatting data series, and a menu will appear on the right side.

So that Incomplete will pick automatically. With the help of a double doughnut chart, we can show the two matrices in our chart.

Now we will create a doughnut chart as similar to the previous single doughnut chart. Select the data alone without headers, as shown in the below image.

Click on the Insert menu. Go to charts select the PIE chart drop-down menu. From Dropdown, select the doughnut symbol. To reduce the doughnuts hole size, select the doughnuts and right-click and then select Format data series. Now we can find the option Doughnut Hole Size at the bottom where you drag the percentage to reduce. We can observe the difference between 0 degrees and 90 degrees.

If we want to increase the gap between the rings, adjust the Doughnut Explosion. Observe the below image for reference. If we want to add the shadow, select the middle option, which is highlighted. At the same time, we obtain Cash an asset by summing the bottom-line result of the Cash flow statement with previous year Cash Flow — Excel Template The cash flow statement shows how a company generated and spent cash throughout a given timeframe.

An important truth. An important truth that is frequently neglected by inexperienced business owners is that profit does not equal cash. Every business owner and manager needs to have a clear idea of the cash flows The Balance sheet shows what a company owns assets and what it owes liabilities Moreover, it can contain more than one data series at a time.

In the PIE chart, we need to create two pie charts for two data series to compare one against the other, but doughnut makes life easy for us by allowing us to create more than one data series. In this article, I will show you the process involved in creating a doughnut chart. Download the workbook to follow with me. Following are the steps for creation of doughnut chart in excel using single data series —.

We have seen how cool the Excel doughnut chart is when we compare it to the pie chart. Now we will see how we create doughnut for two data series values. We can fit these two data series in on Excel doughnut chart only. Follow the below steps to create a doughnut chart in Excel, which includes more than one data series.

It will expand the slices. Step Change the color of each slice to a nice-looking color. Note: Adjust the size of the data labels manually to make it appear cleanly.

Step You can make changes according to your preferences.