Resizing a Chart

FaulkP

New Member
Joined
Oct 25, 2006
Messages
35
Hi,

I have done a search regarding the resizing of a chart and found a number of useful posts. However, what i am attempting to do is have a general piece of code that i can use.
I have a spreadsheet with about 9 different charts on it, all of the chart are very small so that they can be seen in 'one screen view'. What i would like to do is once a chart is clicked it is enlarge to fill the screen, when it is clicked a second time it would reduce to its original size.
Am i right in thinking that one sub routine could be applied to all 9 charts.
Please could you offer me some guidance.

thanks
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top