If you have been looking for a way to S
ave Excel chart as Imageon your Windows or Mac PC then stay tuned and read through all guides here. 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.
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 Open Microsoft Paint ( Commonly Known as Paint) Then Click on paste on the Top left border of your Screen 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.
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
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 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)
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. You’ll see the paste special; click on it and then a dialogue opens,
You have the choice to choose from either:
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 as type – ( .htm or.html)
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.
3. Assign a name to your and enable it on ONLY this work book.
Click on create and then a visual editor pops up.
Now copy this macro and paste it in that Box( in the 2nd line)
ActiveChart.Export “D:My ChartsSpecialChart.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.