How do I resize a chart on a button click?

[olivetwist]

I have a sheet with 4 charts on it. All the same size. I am trying to make it so that when you click on a button associated with a chart it will make it larger for a more detailed view. I am not trying to make it maximize, I want it to change to a specific size. I have come to the conclusion that I will need to use a macro to do this. any guidance or other ideas are appreciated.

Thank you

[Nicole-Smith]

You could make a linked copy of the chart that is a different size and use variables to show/hide the small and large charts.

[awhitfield]

Hi Oliver,

see the attached simple HOW to QVW.

Andy