Excel Export Chart As An Image Add-in

For some time I have needed to export various Excel Charts to an image for consumption in other programs. I’ve always been amazed that Microsoft never directly added the option to do so in the right-click context menu.

Thus, I created a small utility to make this process painless, save me some time and frustrations and decided to convert it into a proper add-in and offer it here in the hopes it might serve others.

The Add-In Ribbon

The add-in adds a simple tab named CARDA Tools to the existing ribbon with 3 buttons as shown in the image below.

Excel - CARDA Tools Add-in

Exporting A Single Selected Chart

By clicking on the Save Chart As An Image button you will then be presented with the following form.

Excel - Export Chart As An Image

Simply add the path and filename to be given to the image, select the format and what you’d like to do once the image is created and press the Export button. That’s it.

Exporting All The Charts In The Excel WorkBook

By clicking on the Save All Charts As Images button you will then be presented with the following form.

Excel - Export All Charts As Images

Simply add the path to export the images to, select the format and what you’d like to do once the image is created and press the Export button. That’s it.

Note
If the a Chart has a Title, then it will be used when saving each chart as an image for its’ filename. If not, then Excel’s internal object is used instead.

Exporting A Selected Range of Cells

I thought I was done, for now, and then I suddenly remembered that I had created a VBA function to Save A Range As A JPG Image and thought this would be a perfect addition to this add-in! So version 1.002 was born.

By clicking on the Save Cells As Images button you will then be presented with the following form.

Excel - Export Range As Image

Simply add the path and filename to be given to the image, select the format and what you’d like to do once the image is created and press the Export button. That’s it.

So now you have a very simple way to Export any Range of Cells from Excel to an image at the click of a button!

Feel free to drop a comment of other features that might be useful to add to this tab.

Disclaimer/Notes:

All code samples, download samples, links, ... on this site are provided 'AS IS'.

In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.

Download

Feel free to download a copy by using the link provided below:

Download “Excel - CARDA Tools Add-In” Excel_AddIn_CARDATools_V1.002.zip – Downloaded 4521 times – 146.76 KB

Download History

Date Version Summary of Changes
2021-09-24 1.000
  • Initial Release
2021-09-25 1.001
  • Added Export All Charts to Image capabilities
2021-09-25 1.002
  • Added Export Cells/Range As Image capability
  • Code cleanup and optimizations
  • Modified Userform so you couldn’t accidentally select the footer area and loose the focus.

2 responses on “Excel Export Chart As An Image Add-in”

    1. Daniel Pineault Post author

      I’m not sure if it can be done. I know there exists an align attribute, you could try using it. I seem to remember a discussion about this a while back and I think the consensus was it wasn’t possible. You should post this type of question in a good Office forum so more people can participate and perhaps help.