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

In this article, we will learn to save an Excel chart as a high resolution image. Often, users perform different data analysis operations in Excel and plot the results on charts or graphs. After plotting the charts, we need to save them as high resolution images to represent them in a presentation. Today, we will demonstrate 6 easy ways. Using these methods, you can easily save an Excel chart as a high resolution image. So, without any delay, let’s start the discussion.

Save Excel Chart as High Resolution Image: 6 Easy Ways

To explain the methods, we will use a dataset that contains information on the sales amount of the first two months of sellers. We will plot the sales amount on an Excel chart and save it as a high resolution image.

After plotting, the Sales Chart will look like the picture below. We will save it as an image using the 6 methods.

1. Save Excel Chart as High Resolution Image Using Context Menu

In Excel 365, we can use the Context Menu to save the chart as a high resolution image. This process is straightforward. Let’s follow the steps below to know how we can save a chart as an image.

STEPS:

• First of all, right–click on the top corner of the chart to open the Context Menu.
• Secondly, select Save as Picture from there. It will open the Save As Picture dialog box.

• After that, select a folder where you want to save the chart in the Save As Picture dialog box.
• Then, type a name in the File name field and select Portable Network Graphics (*.png) in the Save as type field.
• Click on Save to proceed.

• Finally, you will see the saved image in the desired folder.

Read More: Save Excel Table as Image with High Resolution

2. Use Microsoft PowerPoint or Word to Get Chart as High Resolution Image

We can also use Microsoft PowerPoint or Word to save an Excel chart as a high resolution image. For that purpose, you need to copy the excel chart and paste it into the mentioned applications. This process is effective if you save a small number of charts. Let’s observe the steps below to learn the method.

STEPS:

• Firstly, right–click on the top corner of the chart to open the Context Menu.
• Select Copy from there.
• Alternatively, you can click on the chart and press Ctrl + C to copy the chart.

• In the second step, open Microsoft PowerPoint or Word.
• We are using Microsoft PowerPoint.
• After opening PowerPoint, you will see a blank slide like the picture below.

• Now, right–click on the slide to open the Context Menu and select the Paste Images option.
• You can also press Ctrl + V to save the image.

• As a result, you will see the chart on the slide.
• You can resize it using the Double Header Arrow.

• After that, click on the File tab.

• Then, select Save As and then, click on Browse. It will open the Save As dialog box.

• In the Save As dialog box, select a folder where you want to save the chart.
• Then, type 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.

• A Microsoft warning message will appear.
• Click on Just This One to move forward.

• In the end, you will see the image in the desired folder.

3. Apply Microsoft Paint to Acquire Chart as Image

Another way to save an Excel chart is to use Microsoft Paint. This process is similar to the previous one. We are using Microsoft Paint instead of PowerPoint. So, without further delay, let’s follow the steps below.

STEPS:

• To begin with, you need to right–click on the top corner of the chart to open the Context Menu.
• Select Copy from there.
• Alternatively, you can select the chart and press Ctrl + C to copy the chart.

• Secondly, open the Microsoft Paint application.

• Thirdly, press Ctrl + V to paste the chart.
• Then, you need to resize it to remove the blank space.

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

• In the following step, select the File tab and click on the arrow icon of the ‘Save as’ option.
• Here, you will see different formats of images.
• We have selected the PNG picture format.

• In the Save As dialog box, select a folder where you want to save the chart.
• Then, type a name in the File name field and select PNG (*.png) in the Save as type field.
• Finally, click on Save to proceed.

4. Make Chart as High Resolution Image by 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 you get other information with the image in the PDF file. Here, we will use the same chart. Let’s follow the steps below to learn the method.

STEPS:

• In the beginning, drag the chart down just below the dataset.

• Secondly, click on the File tab.

• In the third step, select Save As and then, click on Browse. It will open the Save As dialog box.

• After that, select a folder where you want to save the chart in the Save As dialog box.
• Then, type a name in the File name field and select PDF (*.pdf) in the Save as type field.
• Next, click on Save to proceed.

• Finally, the chart will be saved as a pdf file in the desired location.
• If you open the PDF file, you will see the chart in it.

5. Get Chart as High Resolution Image by 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. It will create a folder for you in the desired location and save all the charts as PNG images in that folder. This process is simple and quick. Let’s pay attention to the steps below to see how we can save an excel file as a web page.

STEPS:

• Firstly, click on the File tab.

• After that, click on Save As and select Browse. It will open the Save As dialog box.

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

• A warning message will appear.
• Select Yes to move forward.

• Now, if you go to the desired location, you will see one folder and a .htm file.
• You need to open the folder.

• After opening the folder, you will see all the images there.

• In our case, image010 contains the chart.

6. Apply VBA to Save Chart as High Resolution Image in Excel

In Excel, VBA gives users the opportunity to do many difficult tasks easily. We can also use a VBA code to save an excel chart as a high resolution image. We will discuss more in the following steps. So, let’s pay attention to the steps below to learn this method.

STEPS:

• First of all, click on the chart and see its name.
• Also, remember the sheet name. We will use this information inside the VBA code.

• Secondly, go to the Developer tab and select Visual Basic. It will open the Visual Basic window.

• In the Visual Basic window, select Insert and then, select Module. This will open the Module window.

• Now, type the code in the Module window:

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

• Press Ctrl + S to save the code.
• After that, go to the Developer tab and select Macros.

• In the next step, select the code and Run it from the Macro window.

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

Download Practice Book

You can download the practice book from here.

Conclusion

In this article, we have discussed 6 easy methods to Save an Excel Chart as a High Resolution Image. I hope this article will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.

Related Articles

• How to Save Image from Excel as JPG
• Save Picture from Excel to Folder

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