How to open a chart by selecting something in another chart?

[jblomqvist]

Hi all,

How can I activate a chart by making selection in another chart?

For example:

Chart A is a bar chart with three dimension values displayed, Good, Average, Poor.

If I select Poor it should trigger another chart to open in the sheet.

Is there a way to do this?

[#2]

Use triggers or actions

[a_mullick]

Hi,

Yes, in the layout tab of the second chart select Conditional:

And set the condition to GetSelectedCount(<Your_field_name>) = 1

Thanks,

Azam

[a_mullick]

And if it is only the case when you select the value 'Poor', then make the condition:

GetSelectedCount(<Your_field_name>) = 1 AND

GetFieldSelections(<Your_field_name>) = 'Poor'

Azam

[Anonymous]

Hi John,

Yes there is a way to do the above. On your dimesions, you can add two small buttons on overlay two objects over the dimensions and make them transparent. Create a variable, call it whatever you want. The initial value will be 0. When you click on the button, the variable value should turn to 1. In your "Invisible graph," in the Layout Tab, you will put the following code in the conditional statement: =if(<VariableName>=1,1,0). Press Ctrl+Shift+S to show and hide.

If you click on the dimension, it should activate the "invisible graph".

[gautik92]

create a button and add action activate sheet and mention the sheet id

[josephinetedesc]

Is it possible to have a button with a trigger which opens another chart - on another sheet?

[gautik92]

ya it is possible

[Anonymous]

Hi John ,

I have sent a application. please check i hope this helps u .

Thanks,

Bunny