In chapter 6 of Loren Abdulezer’s “Dashboard Best Practices” he has an example of a dial control that is linked to a cell that contains a formula. The dial displays the results of the formula, but can also control the value in that same cell. His downloaded example works, but if I try to recreate it myself, I can’t get the dial to control the cell value. I’ve contacted the author but have not heard back.
What am I doing wrong?
bregent (BOB member since 2004-02-06)
By the way, his examples are on an older version than the one I have.
I was able to replicate what he had in his book by using multiple dials (one on top of each other). They were made visible using dynamic visibility which was set by the radio button selector value. I aligned the radio buttons over one another so they appeared to be one.
Regards,
Randy
Randy Jones 
(BOB member since 2002-08-19)
Thanks Randy. I thought about using multiple dials but actually solved it a different way.
First I removed the formula from that cell (C3). Then I added another insertion series to the radio button selector.
Insertion Type: Value
Source Data: Sheet1!$E$3:$H$3
Destination Data: Sheet1!$C$3
Insert On: Interaction Only.
When a selection is made, the appropriate value is inserted into that cell.
I think the version of Xcelsius that Loren used must of had a bug/undocumented feature that was later removed. I’m running SP3.
bregent (BOB member since 2004-02-06)