Assign value to pie chart

[FrancisZheng]

Hello everone,

Say I have 3 cells A1, A2, A3. I have a pie chart already created, I want the value of A1 to be 100% of the pie, so that we can show the percentage of A2 and A3 to A1 on the pie chart. How can I do this?

Thanks in advance.

Francis

[Paul_Hossler]

A pie chart is always 100%

So if

A1 = 100%
A2 = 40%
A3 = 60%

make the chart using A2 and A3 only

[FrancisZheng]

Thank you for the answer.

Actually A2 + A3 isn't necessarly 100%. They are independant. They are both part of A1. That's why I want A1 to be 100%.

[Paul_Hossler]

Still not sure i'm following you but

A2 = 30%
A3 = 60%
A4 = 1 - A2 - A3

and plot A2, A3, and A4 in a pie

[FrancisZheng]

Hello,

A1 is for number of mails. A2 is for number of mails read, A3 is for number of urgent mails. They are independant.

So it could be A1=100%, A2=75%, A3=60%.

Francis

[Paul_Hossler]

Well, a pie chart still has to be 100%

So maybe changing the slice definition (blue chart) or using two charts

18366

[FrancisZheng]

Yes, I think using 2 pies might be the only solution. Thank you.

[Paul_Hossler]

If you're willing use a different type of chart, maybe a stacked column chart would work

Two different Series depending on what you want to show


18370

[FrancisZheng]

Yes, this is good too. Thanks!