drill to pie

[system]

Xcelsius 2008 SP5.

I have a pretty stacked bar chart of hours worked by various grades of staff (chosen via list builder). I can drill into this and capture the data from the bar clicked on by the user. I can put a pie over this - thus showing the detailed data from the bar selected by the user.

What I can’t figure out is how to control the visibility. I want the pie to appear when the bar is clicked on and disappear when the user clicks on a toggle/push button to close. But I can’t work out how to “capture” a mouse click on the bar chart. I’m sure it shoud be doable.

Debbie

---

Debbie (BOB member since 2005-03-01)

[system]

As I understand it >

On Open, A1 = 0

Configure the Barchart to pass Its Value to A1.

Create a lookup range that uses A1 as a reference and supplies your Pie.

@ B1 have a formula that says =if(a1>0,1,0)

DynamicVis property on the Pie looks at B1 for 1

PushButton component (your “close” button) sends a 0 back to A1 on Push,which resets the A1 to 0, which sets B1 to 0, thus closing the Pie

---

Cairmor (BOB member since 2008-06-05)

[system]

But A1 is never = 0 as I have to have a default selection in my bar’s drill…

Debbie

ETA: Oh I’ve got it. Had to create a dummy null series on the bar chart and set that as the default. Works perfectly now! Thank you. 8)

---

Debbie (BOB member since 2005-03-01)