Skip to main content

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

Author: Xiaoyang Last Modified: 2024-12-12

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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:

shot-export-graphics-1


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 shot-export-graphics-2 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.

shot-export-graphics-3

Note:
1) The Preview section displays the preview of the selected chart;
2) If you check the Show Graphics box in the lower left corner of the dialog box, when you select a chart in the Graphics list, Excel will navigate to the selected chart in the workbook.

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.

shot-export-graphics-4

The checked charts are now exported to the specified folder.

shot-export-graphics-5


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 shot-export-graphics-2 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.

shot-export-graphics-6

Note:
1) The Preview section displays the preview of the selected item;
2) If you check the Show Graphics box in the lower left corner of the dialog box, when you select an item  in the Graphics list, Excel will navigate to the selected chart in the workbook.

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.

shot-export-graphics-7

The checked items are now exported to the specified folder.

shot-export-graphics-8

Note:
1. You can only export pictures or shapes from the current workbook to a certain folder as you need. In the Export Graphics dialog box, select Pictures or Shapes in the Types drop-down list, and follow the same steps above;
2. This feature provides 5 export format: GIF, JPEG, TIF, PNG and PDF.
3. Up to 10 directories are kept in the Save directory drop-down list, you can clear all records by clicking Clear Input Record in the save directory drop-down list.

shot-export-graphics-9


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

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon