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.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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.
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.