How to Save an Excel Chart as an Image

save chart as image - How to Save an Excel Chart as an Image 3

The XLS/XLSX format is useful for processing data with Microsoft Excel. However, if someone wants to see the chart without the hassle of Excel, it’s best to convert it into a commonly used format like JPEG as virtually modern devices support the extension.

But how to convert a complex Excel chart into a simple plain image format? Taking a screenshot is one quick way, yet it’s not the most elegant solution. Instead, we are going to go through some of the best methods to save an Excel chart as an image.

The image would appear sharp, detailed, and most or all content from in the chart is covered. You may try each one of these methods to find the perfect way for your use case.

#1 Using the Web Page method

We will essentially take advantage of the Web Page format in Microsoft Excel to convert charts into images. However, please note that some charts and diagrams are not necessarily transformed to image files with this method.

1. Prepare the Excel file.

excel file - How to Save an Excel Chart as an Image 5

2. Go to File.

file - How to Save an Excel Chart as an Image 7

3. Navigate to Save As and click Browse.

save as browse - How to Save an Excel Chart as an Image 9

4. Under the ‘Save as type’, make sure you select Web Page. Then hit the Save button.

web page - How to Save an Excel Chart as an Image 11

5. If you receive this notice, just click Yes.

yes 1 - How to Save an Excel Chart as an Image 13

6. Then locate the HTML file of the excel file. Open it with a browser.

html file - How to Save an Excel Chart as an Image 15

7. After the page is loaded, right-click on a chart and click Save image as…

save image as - How to Save an Excel Chart as an Image 17

8. Select the download directory and click Save. Now you have the PNG version of the XLXS file.

save image png - How to Save an Excel Chart as an Image 19

As I outlined before, some charts and diagrams may not be converted into images. If that was the case, try a different method.

#2 Save to PDF first and convert it to an image

PDF is a universally-accepted format and there are plenty of free tools that convert a PDF file into something else, like JPEG for example. Microsoft Excel thankfully allows you to save an XLSX file as a PDF. This would make the process a lot quicker.

1. First, open the Excel file you want to convert.

excel file 1 - How to Save an Excel Chart as an Image 21

2. Click File.

file 1 - How to Save an Excel Chart as an Image 23

3. Select Save As, then click Browse.

Advertisement
browse - How to Save an Excel Chart as an Image 25

4. Select PDF as the file type, and click Save.

pdf - How to Save an Excel Chart as an Image 27

5. Visit Smallpdf – PDF to JPG converter. Upload the PDF file.

choose file - How to Save an Excel Chart as an Image 29

6. Select Convert entire pages and hit Choose option. The conversion will be started.

convert entire pages - How to Save an Excel Chart as an Image 31

7. Once finished, Download the file.

download image - How to Save an Excel Chart as an Image 33

8. It’s stored in ZIP, so you need to extract it first. I’m using 7zip, but feel free to use anything else.

extract file - How to Save an Excel Chart as an Image 35

9. And the image file(s) is ready to use.

excel image - How to Save an Excel Chart as an Image 37

#3 Use Microsoft Word to save it as a picture

If you don’t want to rely on third-party services and prefer to work offline, then this is the best method. Microsoft Word lets us save a chart into a regular image format and we are going to utilize the feature.

1. Select the chart you want to convert.

click chart - How to Save an Excel Chart as an Image 39

2. Then go to Home > Copy.

copy 1 - How to Save an Excel Chart as an Image 41

3. Next, open a new document in Microsoft Word.

word - How to Save an Excel Chart as an Image 43

4. Navigate to Home > Paste > Paste Special…

paste special - How to Save an Excel Chart as an Image 45

5. Select Picture, generally, PNG and JPEG are preferable. Then click OK.

picture - How to Save an Excel Chart as an Image 47

6. Now, right-click on the chart, and select Save as Picture…

save as picture - How to Save an Excel Chart as an Image 49

7. Select the save directory and click Save to extract the chart as an image.

save picture chart - How to Save an Excel Chart as an Image 51

And that’s how to save Excel charts as images. There are actually many other methods that didn’t get into this article due to their level of complexity. But I how these methods are good enough for your work.

Advertisement

Leave a Comment

Your email address will not be published.