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
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