OmniDocHow to save Excel charts as pictures or high-definition pictures
Explain clearly the two methods of saving Excel charts as pictures and copying them as pictures, as well as how to make pictures suitable for printing and projection, and also includes the idea of batch exporting multiple charts. The steps are all completed in Excel.
Key points of this article
- When there is only one picture, there are fewer steps to select the chart area, right-click and save as picture, and the PNG format is suitable for most scenarios.
- To insert into Word or PPT and keep it clear, copy and paste selectively as an enhanced metafile, which is not easy to blur when enlarging.
- Before printing or projecting, enlarge the chart area and increase the font size before exporting to get more pixels and clearer text.
- Excel does not have a button to export charts in batches with one click. Multiple charts can be exported one by one using a macro, or saved one by one manually.
Many people finish making Excel charts and then put them into Word reports, PPT, or send them directly to colleagues. They subconsciously save the charts as pictures. But when we really look for a solution, a common situation is that the saved pictures are blurry, deformed after being inserted into the document, or there are more than a dozen charts in a workbook and can only be processed one by one.
This article is written for those who need to export single or multiple charts as images and want them to remain clear when printed or projected. After reading, you will know: what scenarios are suitable for right-clicking to save as picture and copy as picture, how to make the exported pictures clearer, and what to do when exporting in batches.
The following methods are all completed in Excel and do not require additional software installation.
How to save Excel charts as pictures? One sentence conclusion
As long as there is one picture, it can be used for web pages, chats or simple documents. It is easier to right-click the chart area and save it as a picture. If you want to insert it into Word or PPT and keep it clear, it is recommended to copy it and use Paste Special, and select the enhanced metafile in the picture form. When printing, enlarge the chart first and then export it for a more stable effect.
| your situation | Recommended practices | reason |
|---|---|---|
| Just a picture, post it on the web or chat | Right-click the chart area and select Save Image as Format PNG | Fewer steps, get image files directly |
| To insert Word or PPT, I hope it will not be blurry after zooming in. | Copy the diagram and use Paste Special to select the enhanced metafile | Lines and text remain clear after vector content is enlarged |
| To print, the font size of the chart is too small in the layout. | First drag the chart area to make it larger, increase the font size, and then save it as a picture. | More pixels are exported, and text is less likely to blur when printing. |
| There are many charts in a workbook | Export one by one with a macro, or save as images one by one manually | Reduce repeated operations and make file naming more uniform |
Before you start: Confirm these points first
Decide what you're going to use the export for before you do it, as this will determine your choice of format and size.
- Where to use pictures. When posting web pages, chats or PPT, PNG is more versatile; when putting it into Word or PPT and need to scale it later, vector format is preferred.
- Whether a transparent background is required. PNG supports transparent background, JPG does not. There is not much difference between the two when the chart has a background color, but when it is to be superimposed on a colored page, a transparent background is more suitable.
- The chart is currently complete. The legend, title, and axis labels will only be exported if they are within the chart area. Before exporting, make sure that the content does not exceed the chart border.
- Whether the data has been finalized. What is exported is a static image. If you change the data later, it will not be automatically updated and needs to be re-exported.
- Whether batch processing is required. Manual operation is faster when there are only one or two charts; when there are many charts, consider the batch method below.
Steps to export a single chart by right-clicking and saving as image.
- Open the workbook containing the chart, click the blank area of the chart with the mouse to select the entire chart. When selected, borders and control points will appear around the chart.
- Right-click on the blank space of the chart. Do not click on the columns, polylines or legends, otherwise the right-click menu will correspond to local elements.
- Select Save as picture in the menu.
- Select the save location in the pop-up save window and enter a file name that is easy to identify.
- Select the image format in Save as type. Usually PNG is selected; if there are file size requirements and a transparent background is not required, JPG can be selected, but JPG is lossy compression and noise may appear at the edges of the text.
- Click Save, then open the folder to check whether the image is complete and whether there is any missing legend or title.
Want HD Pictures: Three Ways to Improve Definition
Clarity mainly depends on the number of pixels and format when exporting. The following three methods can be combined as needed.
One way is to enlarge the chart area and save it. After selecting the chart, drag the control points to enlarge the chart, increase the font size of the coordinate axis and legend, and then save it as a picture. Exported pixels increase with chart size, so a chart that looks the same on the screen will be clearer after exporting.
The other is to copy it as a picture. In Excel's Paste drop-down menu, select Copy as picture, and then select Print effect. The display effect of this method is closer to the printed result than taking a direct screenshot, and is suitable for charts that are ready to be printed or inserted into documents. You can then paste it into Word or PPT.
The third method is to paste using enhanced metafile. In Word or PPT, when pasting the diagram, turn on Paste Special and select Enhanced Metafile (EMF). This format preserves vector information, so lines and text remain neat when enlarged to a full-page projection. It should be noted that if some special effects are set in the original chart, the style after pasting may be slightly different from that in Excel. Please check it after inserting.
How to save multiple charts in batches
Excel does not have a button to export all charts in batches with one click. There are two common methods.
One is to manually save one by one. When the number of charts is not large, follow the steps above to select one by one, right-click to save, and change the file name to the corresponding content. The workload is controllable and it is not easy to make mistakes.
The second is to use a VBA macro to loop the export. The macro can loop through each chart object in the worksheet and call the export method one by one to save to the specified folder. You need to enable macros in Excel before use, and only run macro code from trusted sources to avoid security risks. If you are new to VBA, you can test on a copy first to make sure the output location and filename are as expected.
Check each item after completion
After exporting the image, it is recommended to check the following, especially if it is to be used for formal materials.
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Is the chart content complete? | Title, legend, axis labels, and data labels are all in the figure | Enlarge the chart area and re-export, or adjust the legend position and then export. |
| Is the text clear? | Enlarge the display ratio or view it in full screen in PPT, whether the edges of the text are blurry | Increase the font size, use enhanced metafile pasting instead, or increase the chart size |
| Is the color consistent with the original image? | Compare charts in Excel and exported pictures | Check whether the color cast is caused by the format being JPG, and re-export using PNG. |
| Is the size appropriate for the purpose? | After inserting the document, does the picture fill up the page or is too small? | Adjust the width of the image in the document, keeping the aspect ratio unchanged |
| Whether the data is a new version | Compare with new values in worksheet | Re-export the data after modification and replace the old file |
📊 Core comparison
The common export methods each have their own emphasis and can be selected according to the purpose.
| Way | Output form | Suitable for the scene | Things to note |
|---|---|---|---|
| Right click and save as picture | Bitmap (PNG or JPG) | Single chart, post to webpage or chat | Clarity depends on chart size and may appear blurry when enlarged |
| Copy as picture (such as print effect) | Paste to use as image | Preview a document before printing or inserting it | After pasting into other software, it is usually a picture, which is inconvenient to modify. |
| Paste Special as Enhanced Metafile | Vector graphics (EMF) | Insert into Word or PPT, need to enlarge | Special effects may vary, please check after insertion |
| Macro batch export | Bitmap or other format | There are a lot of charts in the workbook | Macros need to be enabled, it is recommended to test on a copy first |
❓ Frequently Asked Questions (FAQ)
1. Why are pictures saved as pictures blurry than those seen in Excel?
The exported pixel size is related to the size of the chart on the screen. The smaller the chart area, the fewer pixels the image has. It will usually be clearer if you enlarge the chart area and increase the font size before exporting.
2. The color of the chart changes after saving it as JPG. What should I do?
JPG is a lossy compression format and colors and edges may be biased. If you are sensitive to color, just re-export using PNG instead.
3. Can the chart be saved directly as PDF so that it will be clearer when printed?
You can save the worksheet containing the chart as a PDF first, and the vector content will maintain better clarity when printed. If you only need the chart itself, you can also copy and paste it into PPT, and then export it from PPT.
4. Can charts obtained by scanning or screenshots be converted back to Excel data?
The screenshot obtained is a picture and cannot be directly restored to table data. If the original data is still there, it is recommended to go back to Excel and re-export it; if there are only pictures, you need to manually read the values and re-draw the graph.
5. The position or size of the chart is wrong after being put into Word. How to adjust it?
Select the image in Word and drag the corner control points to resize it while maintaining the aspect ratio and avoiding distortion. The text wrapping settings in the document will also affect the position of the image, which can be adjusted according to the layout needs.
📝 Summary
Excel charts are saved as pictures. Right-click a single picture to save it as a picture. When clarity is required or when inserting a document, it is more reliable to copy and paste with enhanced metafile or to enlarge the chart area first. Multiple charts can be exported one by one manually or in batches using macros. After exporting, check them one by one according to content, clarity and size, and you will get pictures that can be used directly.
