Doughnut Chart - Results V.s Target and showing percentage

**nelson2101** · 05-23-2017, 03:39 AM

Hi All

I've seen a doughnut chart in the excel templates that I would like to replicate but I am failing to understand how they have achieved it (please see attached).

I have a target number and a results number to compare against and I would like to illustrate this as a doughnut progress chart, exactly like the attached.

Most tutorials that I can find on Progress Doughnut Charts already have the data as a percentage.

The attached sheet is seems to be comparing two monetary values as a percentage (TOTAL MONTHLY INCOME Vs. TOTAL MONTHLY EXPENSES) and using that percentage to as a progress chart.

Does anybody know of any tutorials that I can work through to learn how to achieve this?

Many thanks in advance for your help!

**MrShorty** · 05-23-2017, 12:17 PM

Most tutorials that I can find on Progress Doughnut Charts already have the data as a percentage.

It is not clear to me exactly what your question is. In this case, it appears that this spreadsheet is doing the same as the other tutorials. They are computing the percentages in a separate (hidden) sheet ("ChartData"). Then using that range as the source for the doughnut chart. I do not know what the other tutorials were showing you. My guess is that, the only difference between this tutorial and the others is that they hid the ChartData sheet so it would not be visible. Steps I see to creating this doughnut chart:

1) Compute totals (in this case, total income and total expenses).
2) Assign names to these totals. (I assume you already know how to assign names to cells/ranges).
3) Add a new sheet.
4) Use those named ranges to compute the percentages.
5) Create doughnut chart.
6) Hide the sheet with the percentages.

Does that answer your question, or am I missing something?