Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a scatter chart with a bunch of bubbles, one per each country. Is there any way to click on a specific bubble and by doing that to move to another sheet where to show further details behind this bubble/country ?
Thanks !
dani
Dani
Assuming Country is a field, you could add trigger to the OnSelect and OnChange triggers for the field (see Document Properties | Triggers) with an "Activate Sheet" action. The sheet that activates should then be sensitive to the Country selection.
If you want a different tab for each country, then create sheets with the sheetID containing the country, such as SH_France, SH_Germany etc. Then use the expression ='SH_' & Country to select the sheet.
HTH
Jonathan
Dani
Assuming Country is a field, you could add trigger to the OnSelect and OnChange triggers for the field (see Document Properties | Triggers) with an "Activate Sheet" action. The sheet that activates should then be sensitive to the Country selection.
If you want a different tab for each country, then create sheets with the sheetID containing the country, such as SH_France, SH_Germany etc. Then use the expression ='SH_' & Country to select the sheet.
HTH
Jonathan
great thanks Jonathan