Action when I chose a chart

[#1]

Hi guys,

I'd like to do a particular thing but I don't know how.

I hope someone can help me.

I have two containers:

- the firts one with three charts (C1,C2,C3)

- the second one with three pivot tables (T1,T2,T3)

What I'm trying to do is when I chose one of the charts f.i. C1 automatically in the second container table T1 has to be presented.

If I chose C3 chart, T3 table has to be presented.

Is it possible to do it ?

I hope it's clear.

I'm trying using macros but I need a refernce guide where can i find it ?

thank you so much.

[vgutkovsky]

Giampero,

I don't think there's a way to do that. At least, I've never heard of an API that changes the active chart in a container. What I do in these situations in use buttons to set a variable and then unhide charts based on that variable. So, for example, have C1 and T1 be visible when vMyVariable = 1. Then create 3 buttons on your sheet to control the values of vMyVariable. Eliminate the containers altogether and just have the charts/tables themselves on the sheet.

Regards,

Vlad

[#3]

Hi Vlad,

glad to hear you again.

I see. Unfortunately it seems that we can reach the object "container" but we can't reach the objects that are in the container.

I'm still trying and I hope to find a solution but I'm not so confident about it.

Thanks a lot for your solution. I'll try to suggest it (I have to eliminate the containers and I don't know if thay want to do it).

I'll keep trying for a while.

Thanks a lot

Regards,

Giampiero