Saturday, November 10, 2018

How to Save Excel Chart as Image on MS Excel [4 Easy ways]




Save Excel Chart as Image












 If you have been looking for a way to Save Excel chart as Image on your Windows or Mac PC then stay tuned and read through all guides here.

Before I proceed, I'll admit that The Microsoft Excel app is really helpful, in many ways,

 It helps for properly managed Data and information in simply rows and columns

It is amazing to know that we can design charts, either Bar, Pie or Line graphs for our statistical Data,

 Some times we want to save these excel charts as images, but it's not not directly given to us on the Excel app unlike the way it is on Microsoft Power point.

SO let's Give into this.

4 Easy Ways to Save Excel Chart as Image:


Below are some ways to save excel chart as image:




1. Copy Your Graph to a Graphic Package (like-Paint) and then save as Image:


There are 2 ways to do this and I'll List them according to my preference.

a . Copy from Excel and paste to Paint:

I find this one to be Easy,  and that's why I recommend this one first.

  • After Designing your chart move your cursor to the border of the chart


  • Right Click on the Border and Click on Copy
Save Excel Chart as Image
  • Open Microsoft Paint ( Commonly Known as Paint)

  • Then Click on paste on the Top left border of your Screen
Save Excel Chart as Image
  • Your Chart has been Copied,


 To save as Image is the next step:


To save as Image, Follow the steps below.


Simply Save the File by clicking on the Save as option.

There are different Picture Format so it's your Choice but I'll be leaving a preferred Format at the Bottom of this post.

It's a quick and easy way to save excel chat as image


b. Screen shot and Crop Your Excel Screen

This is another Way to export your picture to a Graphic Package.

  • While your Chart is Already prepared, use your CRT + Print screen button and then your screen is saved.

  • Go to Your Paint and Open The Picture

  • Now Crop the Image to fit exactly the chart, and you have your chart.

  • To save as Image use the save as option and select your preferred Format.

But here's why I don't prefer this option and why you too may not like it.


1. It's a little bit more complex and harder than the first one especially when you are not good at combination buttons and cropping accurately

2. When you Crop that Large Screen to that small Chart the Quality of image is diminished Big time, and that isn't good especially when it's for Professional use.

2. Export your Chart to Power Point  and Microsoft Word:


Remember I said the Microsoft Power point has the Save as image option, well, yeah so what If we can export the chart to the Power point app and even Word.

Exporting Excel chart as image to Ms-word is useful especially when you intend attaching the image to a document 

This Method doesn't just help you to save excel chart as image but also helps you to manage your chart linked from your excel in your power-point or Ms-word

Also read: Kingo Root Stuck at 90. Quick Solution 

Export to Microsoft Power Point:

  • After Designing your chart move your cursor to the border of the chart

  • Right Click on the Border and Click on Copy
Save Excel Chart as Image
  • Open Microsoft Power Point, and then paste the chart on one slide ( preferably an empty one)

  • You can use the Ctr+V to paste or you right click and then click on paste ( remember to choose the one with Keep Formatting and Link Data)


 Save Excel Chart as Image


 Why I recommend this is because it's because after exporting your chart some times you may update your Excel File


What the Keep Formatting and link Data  does here is to automatically update your Chart on Power point as the file in Excel is Updated.

Export to Microsoft Word

After Designing your chart move your cursor to the border of the chart


Right Click on the Border and Click on Copy


Open Microsoft Word, and then paste the chart on the Body of the new Document, You can attach it to a report as the case may be.

How to save the Chart in Microsoft Word & Power point as Image:


In this case whether you use the 2007, 2010, 2013 version the pasted chart behaves as an image and doesn't update as you update the Excel file.

How to do this?

  • Copy Your Chart on your Excel and launch the Microsoft word

  • This is what makes it different pay attention closely.

  • Click on the small Arrow at the bottom of the paste icon at the top left hand side of the Screen.
Save Excel Chart as Image


  • You'll see the paste special; click on it and then a dialogue opens,


You have the choice to choose from either:


Save Excel Chart as Image 

  • Bitmap

  •  GIF

  •  PNG

  •  or JPEG.


It's your choice.

Click on one of them and the Click on OK, and done it's Saved.

Save All Charts in Your Excel Work book as Image:


Uh oh that's a bumper if you're to do this your self for each individual images so we though of a way we can do all of this in bulk

And that's possible if you follow these steps below:

  • When all your charts are well prepared go to the file button and click on save as.

  • When the Save as dialog is open, select the following.


Save Excel Chart as Image


  • Save as type - ( .htm or.html)

  • Save  ( Entire Work book)


When you are done selecting them, choose the destination folder you want these to be saved, and click on save button,

All charts will be saved as .PNG extension,


Save Using VBA Macro

I feel its one of the best but hardest ways to save excel chart as image, as you have to copy a code and paste, it becomes harder when you're not friendly with computers so I decided to make it simple for you

If your work require that you regularly save Excel chart to images, the you have to use VBA macro, as it, actually, helps to automate the whole process.

Before now it was just for a single piece of code to be written but with these 4 easy steps I'll give you, you don't need the code any more,

1. In your Excel workbook, switch to the Developer's mode


If you don't see the Developer's mode, it means that it's your first time of creating macro.
SO this is what you do

Go to the File button and click on Options

Click on Customize ribbon

In the right hadn't side of the pop up, select Developer and Click ok.


2. Click on Macros icon in the code group.



Save Excel Chart as Image



3. Assign a name to your and enable it on ONLY this work book.


Save Excel Chart as Image

Click on create and then a visual editor pops up.  


Now copy this macro and paste it in that Box( in the 2nd line)


Save Excel Chart as Image



ActiveChart.Export "D:\My Charts\SpecialChart.png"


Close the Visual editor and then click on the save as button on the File drop down list.



Choose to save your Excel file as .xlsm( Excel Macro- enabled Workbook)

And boom you've done it.



The Best Format to Save the Image.


The best Format for these saved images is .PNG extension why? it's simply for the Following reasons.

Its the best Image format that is well compressed ( saves space) and at the same time maintains high Quality images.

For me .Png extension is the best format to save excel chart as image in either of the 4 ways you use
but if you get it in a different format then you should try using Image format converter


So far we've seen how we can save Excel Chart as Image and also the best format for these images saved, but in your course of this post, do you have any question? 

If you do please leave a comment below and I'll get back to you.

Reactions:

0 comments:

Post a Comment

Why not you tell us what you feel about this post In the comment section below
Be sure to come back I'll reply your comment as Fast as possible
:-)