In Excel for Microsoft 365 on Windows, right-click the chart, choose Save as Picture, select a file type such as PNG, and save it. The resulting picture is a separate, static file: it is easy to share or insert elsewhere, but it will not update when the chart’s data changes. If that menu item is unavailable, use Excel’s Copy as Picture command and paste the chart into an image editor.
What You’ll Need
- A workbook containing the chart you want to export. Save the workbook first if you have made changes you may need later.
- Excel for Microsoft 365 on Windows for the direct Save as Picture method. Some Excel versions and Mac installations may show different options.
- A folder where you can save the image, and a filename you will recognize.
- An image editor such as Paint if you need the copy-and-paste alternative. Paint is included with Windows; a presentation app such as PowerPoint can also work.
Step-by-Step
- Open the workbook and identify the chart. If the chart is on a different worksheet, click that sheet’s tab. Check that the chart looks the way you want before exporting: confirm the title, labels, legend, colors, and data are correct. The picture captures the chart’s current appearance, not a live connection to the worksheet.
- Select the chart itself. Click once on the chart’s outside border, rather than clicking a bar, line, data label, or legend item. A border with selection handles should appear around the entire chart. This tells Excel you have selected the chart object. If you select a single chart element instead, the image may contain only that element or the context menu may offer different commands.
- Open the picture-saving command. Right-click the selected chart and choose Save as Picture. Depending on your mouse or touchpad, you can also use a two-finger click. If a shortcut menu appears for a data point or text label instead, press Esc, click the chart border, and open the menu again. Do not choose Save As from Excel’s File menu: that saves the workbook, not the chart image.
- Choose a folder, filename, and format. In the Save as Picture window, browse to the folder where you want the file. Enter a descriptive name, then select a format from the file-type list. For most charts, choose PNG: it retains crisp text and lines without the compression artifacts that can make chart labels look fuzzy. Choose JPEG if a smaller file matters more than perfectly sharp edges, or SVG if it is offered and you need a scalable graphic. SVG availability can depend on your Excel version and the content being saved.
- Save the image and check the result. Click Save, then open the saved file from File Explorer or the folder you selected. Check the whole chart at normal viewing size. Make sure the title, legend, axis labels, and any footnotes are present and readable. If something is missing or clipped, return to Excel, adjust the chart or its size, and save a new copy.
- Use Copy as Picture if Save as Picture is missing. Select the chart border, then choose Home > Copy ▼ > Copy as Picture. In the dialog, choose As shown on screen to match the current worksheet view, or As shown when printed if the printed layout is what matters. Choose Picture rather than Bitmap when available, then click OK. Open Paint, paste with Ctrl+V, and use File > Save as to save as PNG or another suitable format. On a Mac, use Command+C to copy; if Excel does not offer a picture-copy command, paste the chart into PowerPoint or another app that can export an image.
- Adapt the method for Excel on the web or Mac. Excel for the web may not provide the same Save as Picture command as desktop Excel. If you cannot find it, open the workbook in the desktop app and follow the Windows steps, or copy the chart into an app that supports image export. On Mac, check the chart’s control-click menu first; if Save as Picture is not listed, use the copy-and-paste route. Menu names and available formats can vary by Excel release.
Common Mistakes
Saving the workbook instead of the chart. File > Save As creates another Excel workbook; it does not create a picture. Use the chart’s right-click menu for Save as Picture, or copy the selected chart into an image editor and save it there.
Selecting a chart part instead of the whole object. Clicking a bar, axis, legend, or title can select only that element. Click the chart’s outer edge until handles surround the full chart before you export.
Choosing a format without considering its use. JPEG compression can soften small labels and thin gridlines. PNG is usually a safer choice for diagrams and charts. SVG can scale cleanly in compatible apps, but it may not be supported by the software or destination where you plan to use the image.
Assuming the picture stays linked to the data. A saved chart image is a snapshot. Editing cells or refreshing the chart later will not change the exported file. Save it again whenever the chart changes.
Ignoring the chart’s size before saving. Exporting a small chart and then enlarging it in a document can make text hard to read, especially with a raster format. Resize the chart in Excel before exporting if you know it will be displayed large.
Tips
Pick the format for the destination. PNG is a good default for email, documents, websites, and presentations because its edges and text generally remain clear. JPEG can be appropriate for a chart with a photographic background or when an upload limit requires a smaller file, but inspect the labels afterward. SVG is useful when the receiving software accepts it and you need to scale the graphic without the usual pixelation of raster images.
Make the chart larger before you export. Drag a corner handle to enlarge the chart while keeping its proportions, then save the picture. If the chart has several series or long category labels, consider widening it so the text has room. Increasing the size of a saved PNG in another app does not create extra detail, so adjust the source chart first rather than relying on later enlargement.
Keep a useful filename and a separate original. Names such as quarterly-sales-chart.png are easier to identify than image1.png. Keep the workbook as the editable source and treat the exported image as a shareable copy. If you revise the chart, save a new image or deliberately replace the old one so recipients do not use an outdated version.
Check the intended background and layout. A chart may have a different appearance when shown on screen than when printed, particularly if the workbook uses page layout settings or a colored background. With Copy as Picture, choose the option that matches the final use. Preview the exported image against the background of the document or slide where it will appear.
Use the whole-chart selection for a clean export. If you want only the plot area, Excel does not always provide a separate one-click export for that region. You can save the full chart and crop the image in an editor, but leave a little room around labels so axis text or the legend is not cut off.
Troubleshooting
Save as Picture does not appear. First click the chart border and try the right-click menu again. If the command is still absent, your Excel version or platform may not offer it for that object. Use Home > Copy ▼ > Copy as Picture on Windows, then paste into Paint and save the result. In Excel for the web, opening the workbook in the desktop app is often the simplest workaround.
The saved file is blurry or too small. Confirm that you saved as PNG rather than a compressed JPEG, and inspect the image at its actual size. If the chart was small in Excel, enlarge it there and export again. Avoid repeatedly resizing the saved image, because enlarging a raster file can make text and lines look soft. SVG, when available and supported by the destination app, can be a better choice for resizing.
Part of the chart is missing or cut off. Check that you selected the outside chart border and that the chart itself is not clipped by the worksheet or another object. Increase the chart’s dimensions in Excel, allow enough space for long labels and the legend, then export again. With the copy-and-paste method, inspect the pasted image before saving to confirm the full chart made it across.
The file will not open in the app you need. Check the file extension and choose a broadly supported format such as PNG. If you saved as SVG and the destination does not support it, export another copy as PNG. Do not simply rename the extension: changing a filename from .svg to .png does not convert the image format.
The chart looks different from the worksheet. Review the Copy as Picture setting, especially the choice between As shown on screen and As shown when printed. Also check for selected objects, hidden elements, or a chart background that blends into the destination. Adjust the chart in Excel, export a fresh copy, and compare it with the worksheet before sharing.
Frequently Asked Questions
Does saving a chart as a picture change my Excel workbook?
No. Save as Picture creates a separate image file and leaves the chart in the workbook. You can continue editing the chart in Excel, but the exported picture will not automatically reflect those edits.
Which picture format should I use for an Excel chart?
PNG is a dependable default for charts with text, lines, and solid colors. Use JPEG when file size is more important and slight softness is acceptable. Choose SVG when it is available and the app receiving the image supports it.
Can I save only one bar, line, or label from a chart?
The direct Save as Picture command is intended for the selected chart or object. To keep only part of a chart, save the chart and crop the resulting image in Paint or another image editor. Leave enough space to preserve any labels you need.
Can I save a chart as a picture in Excel for the web?
The browser version may not show the same export command as Excel for Windows. Try opening the workbook in the desktop app. Alternatively, copy the chart into an image-capable app and save it there, checking that the full chart is included.
Will the exported chart remain sharp when I enlarge it?
PNG and JPEG are raster formats, so enlarging them substantially can reveal pixels or blur small text. Make the chart larger in Excel before exporting, or use SVG if Excel offers it and your destination supports vector images.
Can I export a chart on a Mac?
Check the chart’s control-click menu for Save as Picture. If it is not available in your Excel version, copy the chart and paste it into PowerPoint or another app that can save or export a picture. The exact commands and supported formats can differ from Windows.
Related
- Paste Transpose in Excel: Shortcut and Steps
- Print an Excel Column on Every Page: Step-by-Step
- How to Paste a Picture in an Excel Cell and Keep It in Place
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Gantt Chart Setup: Build a Project TimelineTo set up a Gantt chart in Excel, list each task with a start date and finish date,…
- Excel Copy Pivot Chart: Change Its Data Source Safely?Copying a PivotChart in Excel does not normally give the copy an independent data source: the copied chart…
- How to Fix a Chart in Excel: Common Problems and StepsTo fix a chart in Excel, select it and check its source range, chart type, and formatting in…
- Excel Pivot Table: Show All Row ValuesTo show a row label on every line in an Excel PivotTable, select the table, choose PivotTable Design…
- Excel Graph Only Shows Some Data Labels? Fix ItIf an Excel graph shows only some data labels, first check whether labels were added to every data…
- Excel Bubble Chart Color Change: Steps and OptionsTo change bubble colors in Excel for Microsoft 365 on Windows, select the chart, right-click a bubble, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.