save chart as image
It would be nice to be able to right-click on a chart and have an option to save it as an image (jpg, png, ...) to the hard drive instead of copy pasting to another application or using screen capture software.
Interesting idea. Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this feature idea.
As I'm always using PowerPoint as an in between step to save images/screenshot of selection etc. as picture I would be nice to integrate it in Excel as well.
Even better would be to have the option to get the share-link at the same time, once save on OneDrive.
So... it's been over TWO YEARS and it's still not implemented. Is it considered too easy? So it's too low on the totem pole of implementation? Maybe you should have a designated programmer tackle all the easy stuff.
Jim Lear commented
I'm regularly having to copy charts and paste them into a PowerPoint in order to save them as images.
* Google Sheets already has this feature.
* The code already exists. Leverage the combination of the "Insert As Picture" Paste Option and the "Save as Picture" Context Menu within Microsoft Word.
Not sure why this is not implemented in Windows yet. The mac version of office has it.
All charts from a sheet can be exported with this little macro:
Dim objCht As ChartObject
Dim idx As Integer
idx = 1
For Each objCht In ActiveSheet.ChartObjects
objCht.Chart.Export "E:\chart" & idx & ".png", "PNG"
idx = idx + 1
Brian Blaylock commented
It would be so nice to have this functionality built into Excel rather than needing an add-on.
Powerpoint has a similar ability to select multiple objects and save it as an image (an option when you right click a selection of images). Would really love to see a similar button in Excel, i.e. right-click a chart (or selection of cells, other object, etc.) and have the option to "save as image"
You can use a tool from http://www.officefindreplace.com to extract charts as images in various formats.
Ryan MacGregor commented
A few add-ins (Peltier chart utility [http://peltiertech.com], Macabacus [https://www.macabacus.com], and apparently Formuladesk) offer this capability. However, since you can already paste charts as pictures into other Office docs using native functionality quite easily, most users won't ever need to save charts as pictures. This would be a niche feature.
I would hope it would apply to all objects/images/etc... I find it odd how Powerpoint has this feature but Word and Excel do not.
Another work around for this is to save the file to .html format. The chart will be saved separate from the sheet as a .png file.
Charley Kyd commented
And also, enhance that feature so we can save the image easily in VBA!!!
Gareth Hayter commented
The FormulaDesk add-in allows you to do this via the context-menu. Right-click a chart, then 'Save as image'. http://www.formuladesk.com