How to Save Excel Chart as High Resolution Image (6 Easy Ways)

In this article, we will demonstrate 6 easy ways to save an Excel chart as a high resolution image.

To illustrate the methods, we will use the dataset below that contains information on the sales amounts of some sellers over 2 months. We will plot the sales amounts on an Excel chart and save it as a high resolution image.

After plotting, the Sales Chart will look like the picture below.


Method 1 – Using the Context Menu

In Excel 365, we can use the Context Menu to save the chart as a high resolution image.

Steps:

  • Right-click on the top corner of the chart to open the Context Menu.
  • Select Save as Picture.

Save Excel Chart as High Resolution Image Using Context Menu

This will open the Save As Picture dialog box.

  • Select a folder to save the chart.
  • Enter a name in the File name field and select Portable Network Graphics (*.png) in the Save as type field.
  • Click on Save to proceed.

Save Excel Chart as High Resolution Image Using Context Menu

The saved image will appear in the desired folder.

Save Excel Chart as High Resolution Image Using Context Menu

Note: The size of the image will be the same as the chart. Change the size of the chart before opening the Context Menu.

Read More: Save Excel Table as Image with High Resolution


Method 2 – Using Microsoft PowerPoint or Word

We can also use Microsoft PowerPoint or Word to save an Excel chart as a high resolution image. We’ll have to copy the excel chart and paste it into these applications. This process is effective only when a small number of charts need to be saved.

Steps:

  • Right-click on the top corner of the chart to open the Context Menu.
  • Select Copy.
  • Alternatively, click on the chart and press Ctrl + C to copy it.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

  • Open Microsoft PowerPoint or Word. Here we’ll use Microsoft PowerPoint.
  • After opening PowerPoint, a blank slide is presented.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

  • Right-click on the slide to open the Context Menu.
  • Select the Paste Images option.
  • Alternatively, press Ctrl + V to paste the image.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

The chart is pasted into the slide.

  • Resize it using the Double Header Arrow.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

  • Click on the File tab.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

  • Select Save As.
  • In the Save As dialog box that opens, click on Browse.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

  • Select a folder to save the chart.
  • Enter a name in the File name field and select PNG Portable Network Graphics Format (*.png) in the Save as type field.
  • Click on Save to proceed.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

A Microsoft warning message will appear.

  • Click on Just This One.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image

The image is saved in the desired folder.

Use Microsoft PowerPoint or Word to Save Excel Chart as High Resolution Image


Method 3 – Using Microsoft Paint

This process is similar to the previous one, but we’ll use Microsoft Paint instead of PowerPoint.

Steps:

  • Right-click on the top corner of the chart to open the Context Menu.
  • Select Copy.
  • Alternatively, select the chart and press Ctrl + C to copy it.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Open the Microsoft Paint application.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Press Ctrl + V to paste the chart.
  • Resize it to remove the blank space.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

After resizing, the image will look like the picture below.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Select the File tab and click on the arrow icon of the ‘Save as’ option.
  • Select the PNG picture format.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Select a folder to save the chart.
  • Enter a name in the File name field and select PNG (*.png) in the Save as type field.
  • Click on Save to proceed.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image


Method 4 – Saving Excel File as PDF

You can also save a chart as a high resolution image by saving the excel file as a PDF. This method is not recommended because other information is stored with the image in the PDF file.

Steps:

  • Drag the chart down just below the dataset.

Save Chart as High Resolution Image by Saving Excel File as PDF

  • Click on the File tab.

Save Chart as High Resolution Image by Saving Excel File as PDF

  • Select Save As then click on Browse.

Save Chart as High Resolution Image by Saving Excel File as PDF

  • Select a folder to save the chart in the Save As dialog box that opens.
  • Enter a name in the File name field and select PDF (*.pdf) in the Save as type field.
  • Click on Save to proceed.

Save Chart as High Resolution Image by Saving Excel File as PDF

The chart will be saved as a pdf file in the specified location.

If you open the PDF file, you will see the chart in it.

Save Chart as High Resolution Image by Saving Excel File as PDF


Method 5 – Saving as Web Page

If you have lots of charts in your excel file, then you can save the Excel file as a web page. This will create a folder in the specified location and save all the charts as PNG images in that folder.

Steps:

  • Click on the File tab.

Save Excel Chart as High Resolution Image by Saving it as Web Page

  • Click on Save As and select Browse.

Save Excel Chart as High Resolution Image by Saving it as Web Page

  • In the Save As dialog box that opens, select a folder to save the chart.
  • Enter a name in the File name field and select Web Page (*.htm;*html) in the Save as type field.
  • Click on Save to proceed.

Save Excel Chart as High Resolution Image by Saving it as Web Page

A warning message will appear.

  • Select Yes.

Save Excel Chart as High Resolution Image by Saving it as Web Page

In the specified location are one folder and a .htm file.

  • Open the folder.

All the images are displayed.

In our case, image010 contains the chart.


Method 6 – Using VBA

We can also write and run a VBA code to save an Excel chart as a high resolution image.

Steps:

  • Click on the chart and note its name.

  • Go to the Developer tab and select Visual Basic.

  • In the Visual Basic window that opens, select Insert and then select Module.

  • Enter the following code in the Module window that opens:
Sub Save_Chart_as_Image()
Dim FName As String
Dim SChart As ChartObject
Dim oHeight As Integer, oWidth As Integer
Set SChart = Sheets("VBA").ChartObjects("Chart 1")
oHeight = SChart.Height
oWidth = SChart.Width
SChart.Height = 500
SChart.Width = 500
FName = ThisWorkbook.Path & "\" & SChart.Name & ".png"
SChart.Chart.Export FName
SChart.Height = oHeight
SChart.Width = oWidth
End Sub

This code will save the chart in the folder where the Excel file is already saved. We used the sheet name and chart name inside the Set SChart = Sheets(“VBA”).ChartObjects(“Chart 1”) command. In our case, the sheet name is VBA, and the chart name is Chart 1. To save the chart as a jpeg file instead, type .jpeg in place of .png inside the code.

  • Press Ctrl + S to save the code.
  • Go to the Developer tab and select Macros.

  • In the Macro window that opens, select the code and Run it.

  • Go to the location where the Excel file is saved and you will find the chart saved as a high resolution image.


Download Practice Book


Related Articles

<< Go Back to Save Excel as Image | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo