Make a pie chart go from one value to four by changing its data set

[rizzo93]

I'm trying to make a pie chart show one segment under one condition and then four segments under another condition. So basically, I want the set of data to change from just one value to four values.

I tried using OFFSET to define a range that would change its dimensions, but Excel doesn't like me putting in the name of the defined range in the Select Data window.

First condition:
When x=FALSE, show one value at 100% and have its own color.

Second condition:
When x=TRUE, show four values at whatever percentage they are with their corresponding colors.

In essence, I want the pie chart to look as though it's not active (nothing to report) until the condition is true at which time it will show the colored segments. So it would look like a light shade of grey until it comes alive.

Is there a way to do this using formulas?

 

[RoryA]

No, that's how it should be (and what I was getting at).

 

[rizzo93]

Sorry to prolong this, but the name of the defined range keeps reverting back to something other than the name I gave it in the Select Data window.

I decided to make the formula simpler by removing the OFFSET and just telling it to use "this" range of cells in one condition ($G$14:$G$17), otherwise use "that" range ($G$18).

=IF(filters.applied,Calculations!$G$14:$G$17,Calculations!$G$18)​

In the Select Data window I enter "Calculations!ProjectStatusDisk" (without the quotes).

I click OK and return to the window and it shows this =Calculations!$G$14:$G$17 instead. That's the range of the first four values when a condition has been met. The frustrating thing about it though is that the condition has not been met. It's like it's ignoring any change to the data set.

Any thoughts?

 

[RoryA]

You need to edit the series data, not enter the named range in the top box. Select the first {only) series in the list, Edit it, then enter the named range there.

 

[rizzo93]

I got it to work! Thank you very much!