Pie chart of ownershiop percentage

Copper Contributor

In the excel pie chart; I want to make one percentage of the chart unchangeable no matter what other percentage changes are made to the rest of the pie. In other words; If I make a 25% pie slice and change the other 75%, the only percentage changes which can take place are other than the "non dililutable" one for 25%. The 25% pie slice never changes, only the balance of the other slices. Your advise is much appreciated.

 

Dan

1 Reply

Hi Dan

 

You'd need to set up some formula allowing you to hard code the 25%

 

Static Pie Segment.PNG