Jan 20 2017 01:57 PM
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
Jan 20 2017 04:39 PM - edited Jan 22 2017 04:12 PM
Hi Dan
You'd need to set up some formula allowing you to hard code the 25%