PDA

View Full Version : Assign value to pie chart



FrancisZheng
02-13-2017, 09:31 AM
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
02-13-2017, 06:08 PM
A pie chart is always 100%

So if

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

make the chart using A2 and A3 only

FrancisZheng
02-14-2017, 01:38 AM
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
02-14-2017, 07:31 AM
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
02-14-2017, 08:13 AM
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
02-14-2017, 08:51 AM
Well, a pie chart still has to be 100%

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

18366

FrancisZheng
02-14-2017, 09:41 AM
Yes, I think using 2 pies might be the only solution. Thank you.

Paul_Hossler
02-14-2017, 11:14 AM
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
02-15-2017, 02:46 AM
Yes, this is good too. Thanks!