Scatter chart - bubble drill-down

[danialier]

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

[jonathandienst · Accepted solution]

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

[danialier]

great thanks Jonathan