Enlarge a Chart

I have created a dashboard using Pivot charts and have multiple charts all on the same sheet, but they look quite small
What I want to be able to do is click a chart and the chart fills the page, click the chart again and it reverts back to its normal size

Is this possible and how do I go about this

Thanks in advance

Hi shane1966,

See the attached file which has been tested on Excel 2003 and 32 bit Excel 2010. 'Left Click' on a Chart to enlarge. 'Left Click' again to restore the chart to it's original position. Macros must be enabled to run the code.

To port the code to your file:
a. Export module ModEnlargeRestoreCharts from my file. Import it to your file.
b. Run Macro AssignMacroToAllChartsOnActiveSheet() on your file.
c. Save your file.

Complete code follows:

Please Login or Register  to view this content.

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
http://office.microsoft.com/en-us/tr...001150634.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

To import or export VBA code:
a. To export, right click on the Module Name in the 'Project Explorer'.
b. Select export file. I suggest you use a SubFolder that only contains exported (.bas) files.
Keep the original name.
c. To import, right click anywhere in 'Project Explorer'.
d. Select import file. Select a file to import.

Lewis