How to Save Excel Chart as Image: Step-by-Step (2023)
Microsoft Excel charts are of their own kind when it comes to data visualization.
They present the information so precisely, the visuals are crisp, and the charts are so easy to make. Even a newbie can make stunning charts in Excel.
Making charts is one thing – but can you even make an image out of a chart in Excel?
Certainly yes – you will learn in the article below. So let’s get dive in right away 🚀
Also, here’s our sample workbook here for you to download to tag along with the guide.
Table of Contents
How to save an Excel chart as an image
Saving an Excel chart as an image is really simple. Let’s see how you can do it below.
For example, we want to save the following chart as an image.
- Select the chart 📊
- Right-click the chart.
- A drop-down menu appears.
- From this menu, click on the option “Save as Picture”.
- The Save As Picture window opens.
- Select the location where you want to save the picture.
- Select the type of picture. For now, we will save it in PNG format.
- Click on Save.
Your chart will be saved as an image on your PC.
It’s only that simple 🤩
There are many other formats you can save your image file in. These include JPEG format, Tag Image File Format, BMP format, and more.
If you are using this image for a Powerpoint presentation, you can add the image to Powerpoint too. It offers a huge range of editing options 🙌
How to save multiple charts as images in one go
Okay, so we know how to save a single Excel chart as an image. But what if you have to save multiple charts as images in one go?
Yes, you can save each image separately, but what if you have like 20 charts (or even more) ahead of you? It will take you hours to do that.
So can we save multiple charts as images then? Here’s a trick for that📢
- Open the workbook containing the charts.
- Go to the File tab.
- Click Save As.
- Select the folder you want to save the images.
- The “Save As” window appears.
- From the Save as type options, select the “Web Page” option.
- Assign a name to the Excel worksheet. For now, we are setting the file name as “Pie Chart”.
- Press Save.
When you do this, Excel will show a warning prompt. Don’t lose your calm and simply press “Yes”.
The entire workbook is now saved as an HTML file👍
Now for the images of all the charts:
- Go to the destination folder.
- You will find a folder with the same name as your Excel sheet.
- Open the folder.
- All your Excel charts have now been saved as images.
- Click any image to view the chart.
And it opens up seamlessly🥇 That was super easy, no?
That’s it – Now what
This article gives you a comprehensive insight into how to save an excel chart as an image. It also explains how to save an entire Excel workbook with multiple charts as images in one go.
Saving an Excel chart as an image is not only easy and interesting but very useful too. You can quickly extract the chart as an image and share it with others.
In addition to charts, Excel offers a wide range of functions that are equally useful and important. Some of my top favorite Excel functions include the VLOOKUP, IF, and SUMIF functions.
Want to learn them already? Enroll in my 30-minute free email course now to learn these (and many more) functions of Excel.
Do you want to learn how we created the pie chart shown in the images above? Read all about it here.
Also, you might want to read about Excel Infographics here. They are super interesting.