Show a chart if a particular chart is also opened on the same sheet.

[#1]

Hi,

Just need a little help on this. If a user activates a particular chart on a sheet, I then need to show another chart alongside. The 'other' chart is hidden until then.

The first chart is a Pivot Table, I can not find the action settings to activate another sheet object.

Any pointers greatly appreciated.

Thanks

Lee

[martin59]

You have to use variables and conditional showing. Put a button (transparency = 100%) on pivot table's caption which modify the variable value and also show the other objet.

[#3]

A long time ago in a galaxy far, far away.... (Star Wars soundtrack)

OK, here we go. I don't think that events from charts can be set (if so, please send me a smoke signal right now!).

So, you should try to add a button to do this (the button obviously launchs a macro that will activate or deactivate the visibility of the table and the chart). I think this is the better way and remember to block the user to open by himself this chart.

You could try using a "transparent" button too, but I cannot figure it out how to close both at the same time.

Hope it helps!

J

[#4]

That is the bit that is causing me difficulty. I don't want you use restore and minimize becuase I can not run the minimize on both once it is open

[#5]

You should be transparent with the user saying "HEY USE THIS BUTTON" instead of hidding a button (I believe).

I think that it helps to the user to understand that the chart AND the table should be seen both at the same time.

My advice: a button without transparency.

Hope it helps!

[#6]

OK, use conditional showing with a button.

Chart and table are affected by this macro triggered by the button.

[#7]

And don't forget to set minimize, restore and maximize options to make them permanent.

[#8 · Accepted solution]

If you go to Sheet propertiees and go to Triggers Tab, you can Add an action on Activate that object, for example to minimize or restore some other object.

[#9]

Why that is on the Sheet Properties I do not understand ... but thank you for your help! Working beautifully!