Comments on: How to save Excel chart as image, copy or export it to Word & PowerPoint

In this article you will learn 4 quick ways to save your Excel chart as an image (.jpg, .png, bmp. etc.), copy or export it to another file such as a Word document or PowerPoint presentation. Continue reading →

Table of contents

Comments page 2. Total comments: 47

  1. I have one question, I'd like to export the chart to file of the format .bitmap it is possible? Someone know how do this on vba? Glad to be here! Thank you!

  2. I get the same error as cpurandarrao :

    (Error 91)
    fix Object variable not set

    ActiveChart.Export "C:\$user\data\Grafiek_" _
    & "(" & LocalCounter & ").jpg"

    Would appreciate a solution

  3. I have several charts to save at once. Can I do it. Also suggest how to custom name it

    regards

    cpurandar

  4. I tried to save charts from excel sheet but came across a bug

    (Error 91)
    fix Object variable not set

    Please inform how to fix it

    regards

    cpurandarrao

  5. Is there a way to make the "picture" graph look a lot sharper? It doesn't look as good as if you copy and paste from Excel to Word.

  6. Thanks a lot.

    S.Karthikeyan

  7. Hi,

    I love this tutorial but what I wish to achieve is to print current selection of cells and not just a graph. Kindly suggest.

    1. Hi Ayoola,

      Thank you for your feedback. To fulfill your task, please open the worksheet, press the PrintScreen button on the keyboard. Then open any Image Editor, e.g. Paint, press Ctrl + V to paste the image from the clipboard and then crop it leaving only the necessary part of the screenshot.

  8. Thank you very much for this. Was very useful to me.

  9. Thanks a lot. This helped me.

  10. Great! thanks.

  11. Usefull!

  12. I have the same question as lucas, I export my file, but is there a way to increment the file name so it does not save over the prior one?

    1. Hello Kyle,

      I have to ask the same question that I asked of Lucas earlier. Please let me know whether you need to save several charts from one worksheet during one session (i.e. without closing the workbook) or do you need a general solution?

      1. Alexander,
        Let's start with the former. Please describe how to increment the filename for one Excel sheet.
        Thanks

        1. Try something like this.

          Dim LocalCounter%, FS

          Set FS = CreateObject("Scripting.FileSystemObject")

          LocalCounter = 0
          Do While FS.FileExists("D:\My Charts\SpecialChart_" _
          & "(" & LocalCounter & ").jpg") = True
          LocalCounter = LocalCounter + 1
          Loop
          ActiveChart.Export "D:\My Charts\SpecialChart_" _
          & "(" & LocalCounter & ").jpg"

          1. I second! This works great!

          2. thanks joe - that worked a treat :-)

  13. Is there a way to then revert from a picture/image file (let's say *.jpg) and import/back to excel? Thanks!

    1. You can do this using some OCR program. Nearly all of them can scan and recognize .jpg, .png and other images. If this does not work, then you will need to print out the picture and scan it.

      1. Thanks Alexander!

  14. So like one of the methods totally worked. Been preparing for IGCSE ICT and all. Thank you so much.

  15. The solution with the macro works very well. However, do you have a way to add the increment in the destination name to be able to save many files one after each other and not having them saving over the last one.

    1. Hi Lukas,

      We do not have a ready-to-use macro. But I think it won't be a big problem to write one.

      Please specify whether you need to save several charts from one worksheet during one session (i.e. without closing the workbook) or do you need a general solution? The former will be pretty easy while the latter might be challenging.

    1. Sir,
      My query is to all Experts, I have some sort of Data in A2 to D10 in Sheet1 (Don't have Chart) & I want to make a macro button for copying in paint & save in png format in particular Folder (E:\Shahzad\Send\) by the name of Cell A1 (Name mention is in A1) & after saving file it will open.
      Can any one suggest.
      Thanks

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)