pie chart to 100% completion with different numbers.

Edit your post, and scroll down until you see the "Go Advanced" button - click that, and you will find (with a little searching) a "manage attachments" option that you can use to attach a file.

Are the numbers in row 9 manually entered, or are they the result of formulas?

Originally Posted by Bernie Deitrick

Edit your post, and scroll down until you see the "Go Advanced" button - click that, and you will find (with a little searching) a "manage attachments" option that you can use to attach a file.

Are the numbers in row 9 manually entered, or are they the result of formulas?

Thanks for the tip, Bernie, much appreciated.

*Edit2* apparently I needed to post a few more times before I can post links,images ect.

Attachment icon / box still not working as expected, it brings up a small thin window with nothing in it and does nothing but make the message window area flash for a moment.


Row 9 and down in the white cells are manually entered. hundreds of them, every day :D
Row 8 is just a quick E8 cell =C9
The cells in C9-18 are manually entered.
the greyed out cells are basic formulas or static details for staff not to alter, data is entered into the white cells only

The basics of what I was attempting is
C8 = 83 in this instance
the cells below it are manually entered with data.
So C9 would equal 1 entry "ignore the random data", C10 would equal a 2'nd entry and so on until 83 entries are made in that column to reach a 100% entry field to completion.
I was stumped at working out a Doughnut chart to show "current" completion to that C8 "83" number, where 41(ish) would be at the 50% mark and only show half of the Doughnut chart full. If that makes sense ? :D
Thanks.

You could use a simple row of formulas like this

=IFERROR(E201/E8,0)

formatted with CF to be bars, that would show the relative progress of each column of data. "Pie charts are good" said no one ever....

I think donuts are acceptable in this instance, as a simple progress gauge.

You just need 2 values in the chart. Completion and (Target-Completion).
I have used the cells at the top to store those values, under the charts. If you actual need those cells just move the formula to free cells and make sure the chart remain linked to the correct data.