Using VBA to Export Charts as Images in Excel 2007:-


VBA is the macro language behind Excel. You need to display the Developer tab in the ribbon. If this tab is not on your computer, select the Office icon, Excel Options and then check the Show Developer Tab in the Ribbon check box.

When the Developer tab is available, you follow these steps to export a chart to a graphic file:

1. Select a chart.

2. From the Developer tab, choose Visual Basic.

3. Press Ctrl+G to display the Immediate window.

4. Type the following line of code and then press Enter:

ActiveChart.Export “C:MyChart.JPG”, “JPG”

You can, of course, specify any path and filename instead of the name shown in the preceding code snippet. The file type can be GIF, JPG, or any other graphics filter installed on your computer’s copy of Office.