Easily save/export charts/pictures/shapes as image in Excel

Sometimes, you may need to save charts, shapes or pictures in a workbook as image files (.png, .jpeg, .pdf etc.). With Kutools for Excel’s Export Graphics utility, you can easily achieve:

Save or export Excel charts as images

Save or export any Excel charts, pictures and shapes as images

Click Kutools Plus >> Import & Export >> Export Graphics to enable this feature. See screenshot:

Save or export Excel charts as images

Suppose you want to save (export) Excel charts in a workbook as images, you can do as follows:

1. Open the workbook that contains the charts you want to save as images, and then enable the utility by clicking Kutools Plus > Import & Export > Export Graphics.

2. In the Export Graphics dialog box, please configure the settings as follow.

1) In the Types section, select Charts from the drop-down list;

2) In the Graphics list section, all charts in the current workbook are displayed in the list box. By default, all charts are checked, if you don’t want to export a particular chart, just untick the checkbox before it;

3) Go to the Save directory on the right, click the button to select a folder to save the exported charts;

4) In the Export format section, select an image format you need from the drop-down list.

5) Click OK.

3. Another Export Graphics dialog box then pops up, asking if you want to open the directory of the saved images, click OK to open it, or click Cancel to end the whole operation.

The checked charts are now exported to the specified folder.

Save or export any Excel charts, pictures and shapes as images

If you want to save (export) any charts, pictures and shapes in a workbook as images, you can do as follows:

1. Open the workbook that contains the charts, pictures and shapes you want to save as images, and then enable the utility by clicking Kutools Plus > Import & Export > Export Graphics.

2. In the Export Graphics dialog box, please configure the settings as follow.

1) In the Types section, select All from the drop-down list;

2) In the Graphics list section, all charts, pictures and shapes in the current workbook are displayed in the list box. By default, they are all checked, if you don’t want to export a particular one, just untick the checkbox before it;

3) Go to the Save directory on the right, click the button to select a folder to save the exported charts;

4) In the Export format section, select an image format you need from the drop-down list.

5) Click OK to start exporting the checked items.

3. Another Export Graphics dialog box then pops up, asking if you want to open the directory of the saved images, click OK to open it, or click Cancel to end the whole operation.

The checked items are now exported to the specified folder.

  Export graphics

Kutools for Excel: 300 + functions you must have in Excel, 30-day free trial from here