Expansion of pie charts as data changes

[excel_stuff]

Hi,

I have two categories (say group A and B) and relevant numbers for each category. I am using a slider to change these numbers. Then I use a 3D pie chart to represent share of each group in the total pie. Now what I would like is that the pie should do two things:

1. The overall size of the pie should expand/reduce as the total sum of the numbers increase or decrease (which it is currently not doing)
2. It should also show the percentage share of each group (which it is currently doing)

Your help would be greatly appreciated.

Thanks
ExcelStuff

 

[Somendra Misra]

Hi ExcelStuff,

See the attached file.

Regards,

 

[excel_stuff]

Thanks, Somendra, but it doesn't solve problem 1, i.e. I want the overall size of the pie to be bigger when the total sum of the two numbers is say 40 instead of 20. In your sheet, its currently showing me my percentages which I already have.

Thank you!

 

[Somendra Misra]

Kindly upload a file.

Regards,

 

[Somendra Misra]

Something like this.See the attached file.

Regards,

 

[excel_stuff]

Thank you! This is a potential solution, although the whole frame changes when moving the slider but its a starting point.

Thanks
ExcelStuff