How to Save Chart as TIFF Image in Excel

This post will guide you through three different methods to save a chart as a TIFF image in Excel 2013/2016/2019/365.

The first method involves using the “Save As Picture” feature in Excel, which allows you to save a selected chart as a TIFF image with just a few clicks.

The second method involves using the “Copy and Paste” feature to copy the chart as an image and then save it as a TIFF file using an image editing program.

The third and most advanced method involves using VBA code to automate the process of exporting multiple charts as TIFF images.

Save or Export Excel Chart as Picture using Save As Picture Feature

To save or export an Excel chart as a TIFF image using the “Save As Picture” feature, follow these steps:

Step1: Select the chart you want to save as a TIFF image.

How to save chart as TIFF image in Excel 1.png

Step2: Right-click on the chart and select “Save As Picture” from the context menu.

How to save chart as TIFF image in Excel2.png

Step3: In the “Save As Picture” dialog box, select “TIFF” as the file type. Choose the destination folder where you want to save the TIFF image and enter a name for the file.

How to save chart as TIFF image in Excel3.png

Step4: Click the “Save” button to save the chart as a TIFF image.

That’s it! The chart will be saved as a TIFF image in the selected destination folder with the specified filename.

Copy and Paste the Chart as TIFF Image

You can also use Copy and Paste feature to save the selected chart as TIFF image. Just do the following steps:

Step1: Open the Excel spreadsheet that contains the chart you want to save as a TIFF image.

Step2: Click on the chart to select it. Press “Ctrl + C” to copy the chart.

How to save chart as TIFF image in Excel4.png

Step3: Open your preferred image editor (such as Microsoft Paint or Adobe Photoshop).

Step4: Press “Ctrl + V” to paste the chart into the image editor.

How to save chart as TIFF image in Excel5.png

Step5: In the image editor, choose the “Save As” option from the “File” menu. Choose the location where you want to save the TIFF image. Select “TIFF” or “TIFF Image (.tif;.tiff)” in the “Save As Type” dropdown menu. Enter a file name for the TIFF image.

How to save chart as TIFF image in Excel6.png

Step6: Click on the “Save” button.

How to save chart as TIFF image in Excel7.png

Copy and Paste the Chart with VBA Code

If you want to save all charts as TIFF images in an Excel workbook, and you can use a VBA code to do it. Just follow these steps:

Step1: Open your Excel workbook containing the charts.

Step2: Press “Alt + F11” to open the VBA editor.

Step3: In the editor, go to “Insert” > “Module” to create a new module.

Step4: Copy and paste the below code into the module.

VBA save chart as TIFF image in Excel 1.png
Sub SaveChartsAsTIFF_excelgeek()
    Dim myChart As ChartObject
    Dim myPath As Variant
    Dim myFile As String
    
    'Prompt user to select the destination folder
    With Application.FileDialog(msoFileDialogFolderPicker)
        .Title = "Select Destination Folder"
        .AllowMultiSelect = False
        If .Show <> -1 Then Exit Sub
        myPath = .SelectedItems(1)
    End With
    
    'Loop through all chart objects in the workbook
    For Each myChart In ActiveSheet.ChartObjects
        myChart.Chart.Export Filename:=myPath & "\" & myChart.Name & ".tif", FilterName:="TIFF"
    Next myChart
    
    'Display message box when all charts are saved
    MsgBox "All charts have been saved as TIFF images in the selected folder."
    
End Sub

Step5: Press “Alt + F8” to open the Macro dialog box.Select the “SaveChartsAsTIFF_excelgeek” macro and click “Run“.

VBA save chart as TIFF image in Excel 2.png

Step6: When prompted, select the destination folder where you want to save the TIFF images.

VBA save chart as TIFF image in Excel 3.png

Step7: Click “OK” and the macro will save all charts as TIFF images to the selected folder.

Conclusion

Saving charts as TIFF images in Excel is a useful and easy-to-accomplish task that can be done using different methods. If you need to export multiple charts as TIFF images, VBA code provides an efficient and automated solution.

Leave a Reply

Your email address will not be published. Required fields are marked *