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.


Download Practice Book

You can download the practice book from here.


6 Easy Ways to Save Excel Chart as High Resolution Image

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, rightclick 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.

Save Excel Chart as High Resolution Image Using Context Menu

  • 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.

Save Excel Chart as High Resolution Image Using Context Menu

  • Finally, you will see the saved image 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. You can change the size of the chart before opening the Context Menu.


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, rightclick 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.

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

  • 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.

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

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

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

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

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

  • After that, click on the File tab.

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

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

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

  • 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.

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

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

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

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

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


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 rightclick 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.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Secondly, open the Microsoft Paint application.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • Thirdly, press Ctrl + V to paste the chart.
  • Then, you need to 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

  • 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.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image

  • 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.

Apply Microsoft Paint to Save Excel Chart as High Resolution Image


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.

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

  • Secondly, click on the File tab.

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

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

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

  • 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.

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

  • 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.

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


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.

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

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

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

  • 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.

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

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

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

  • 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

This code will save the chart in the folder where the excel file is already saved. In this code, we have 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. Also, to save the chart as a jpeg file, you need to type .jpeg in place of .png inside the code.

  • 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.


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. You can also visit the ExcelDemy website for more articles like this. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo