Log In
Register
Home
October 24, 2017
Offline
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
Offline
Can you please attach an example of your spreadsheet so we can see what is going on?
October 24, 2017
Offline
Excel File attached, bottom charts in dashboard sheet.
July 16, 2010
Offline
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)
