How to save chart as TIFF image in Excel?
As we know, Microsoft Excel does not support users to save a chart as TIFF image directly. In this article, I will introduce a tricky way to save an Excel chart as TIFF image with Paint tool, and a handy add-in of Kutools for Excel to save multiple charts as TIFF images in a minute.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Normally the Paint tool is installed in the Windows OS by default, and we can apply it to save an Excel chart as a TIFF image with following steps.
Step 1: Right click the chart in the workbook which you will save as TIFF image, and select Copy from the right-clicking menu.
Note: You can also copy the chart with clicking it and then pressing the Ctrl + C keys simultaneously.
Step 2: In Windows 7, open Paint tool by clicking the Start button > All Programs > Accessories > Paint.
In Windows 8, open Paint tool with clicking the Paint icon on the start screen directly.
Step 3: Then paste the chart into the Paint editing area with pressing Ctrl + V keys at the same time.
Note: After pasting the chart, do not click anywhere in the editing area to remain the chart selection.
Step 3: Click the Crop button on the Home tab.
Step 4: Save the image with clicking Save button or pressing the Ctrl + S keys simultaneously.
Step 5: In the opening Save As dialog box, you need:
- Open the destination folder where you will save this chart in;
- Enter a name for this chart in the File name box;
- Click the Save as type box and select TIFF (*.tif;*tiff) from the drop down list;
- Click the Save button.
Up to now, the specified chart has been saved as a TIFF image already.
Some users may be not familiar with the Paint tool, and this tool can only save one chart as TIFF image at a time. If you have Kutools for Excel installed, its Export Graphics utility can solve these problems easily.
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel
Step 1: Click the Enterprise > Import / Export > Export Graphics.
Step 2: In the popping up Export Graphics dialog box, you need to do as follows:
(1) In the Graphics list section, click the Types box and select Charts from drop down list.
(2) Now only charts are listing in the Graphic List section, check the charts you want to save as TIFF images;
(3) In the Save directory section, click the Browse button to open the Select a directory for exporting graphics dialog box. In the dialog box, Specify a destination folder and click the OK button;
(4) Click the Export format box and select TIF from drop down list;
(5) Click the Ok button.
Step 3: Now an Export Graphics dialog box comes and shows you how many charts have been exported successfully. Just click OK button to close it.
Note: In Excel 2007/2010, this Export Graphics utility requires TIF Filter installed.
Up to now, all selected charts are exported and saved as TIFF images already.