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?
Can you please attach an example of your spreadsheet so we can see what is going on?
Excel File attached, bottom charts in dashboard sheet.
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
