

October 24, 2017

I have two charts on my Dashboard sheet with option buttons (2 buttons for each chart), and these option button cell links to calculation sheet.
For Chart 1
Option Button 1 Cell link Calculation!$E$6
Option Button 2 cell link Calculation!$E$6
For Chart 2
Option Button 1 Cell link Calculation!$E$7
Option Button 2 cell link Calculation!$E$7
Problem:
cell link for chart 2 changes to cell link for chart 1 (from E7 to E6) and gives formula reference error, i tried with group option but could not succeed. how to solve this formula reference error?


Trusted Members

February 13, 2021



July 16, 2010

Thanks for sharing your file, Irfan. You need to put group boxes around the two sets of radio buttons. I tested it and that resolved the issue. If you tried it before, perhaps you didn't fully enclose the radio buttons properly. The entire radio button object must be inside the group box for them to be in the group.
Mynda
1 Guest(s)
