Pie Chart Values Help

[Cantrecallmyusername]

Hi,
I am having some trouble understanding the calculations been outputted into my chart.
There are some values seen below that I am using to base some charts on a monthly basis which are not outputting the desired results.

This is the series values in my chart - the results I am getting are 36%/64% for October for example where I am expecting 45%/65%.
How would I reflect this in my chart?

 

[Domenic]

For the month of October...

Total hours = 2143 + 1182 = 3325

Scheduled percentage = 2143 / 3325 = 64%

Unassigned percentage = 1182 / 3325 = 36%

How are you calculating your percentages?

 

[Cantrecallmyusername]

Hi,
Thanks for the reply - I am not looking for each total combined to be presented as a percentage of the total rather then as a percentage of each other.
I am using the formula (2143 - 1182)/ 2143 = 45%

 

[Domenic]

In that case, I would suggest that you create another table, based on your original one, with the desired calculations. Then create your chart based on those calculations instead.

Hope this helps!