Saturday, November 10, 2018

How to Save Excel Chart as Image [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 Excel 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

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 later 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.

Wednesday, November 7, 2018

Hackathon Ideas: The Winning Innovation


Hackathon Ideas



Are you planning on going for the Hackathon Event? Or do you know someone that is inspiring to go for it? Then you should need some Hackathon Ideas to give you more chances of winning

Hackathon is a great chance for innovations and inventions, definitely one person is going to win it, but it will be you if you have the Winning Innovation.

So in this post I'll be exposing... you to some cool Hackathon ideas and why they are Winning Innovations.

Cool Hackathon Ideas:



First of all I'll start with why these ideas are cool

Have you noticed that most winning Hackathon ideas over the past few years solved a major problem?


If you are Eagle minded and you realized that, then you should know that for you to win it, you ideas have to solve a problem, a Major Problem.

To make it easier for you I'll be breaking down the ideas in Categories:

1. Education:

Hackathon Ideas


Trust me Education is becoming boring both for the Teachers and the students.

You could think of how you can use Technology to make class lessons easier to understand, much more interesting.

This will indeed involve study tools, but trust me; a lot of persons are looking for solution to this problem.

Idea:


Bringing up an app that students have all their notes pre-handled to them in their phones is one of the ideas I'll pull out to you.

Typically seeing a big book in your front discourages one from reading, but students are more inclined to using their phones to read and study as they are attracted to it.

In Africa Teachers spend 90% of class room time reading out loud or Writing on the board their notes, and students copy them.

 But what about if these notes are pre handled? Students will use 90-100% off class room time doing the actual learning.


This Hackathon Ideas is worth investing on, even if teachers don't vote for you, all the Students will vote for you.

Cyber Bullying:

Hackathon Ideas


This is indeed another problem in the society, if you don't know what cyber bullying is, it's a way of bullying or harassment using Electronics means, majorly Social Media.

This causes emotional pain on young ones and many of them commit suicide after wards.
If you can invest your time bringing up ideas to stop cyber bullying you can win

Idea:


Face book now has the ability to block suspected spam links and also pornographic images.

But what if you design a program or AI that  auto detect cases of cyber bullying either in private chat, or in the News Feed itself, the Comment Box?

And then block that content and even penalize the user

You can design something like that, it is a major idea to solving cyber bullying, it's a great Hackathon Idea.

Environmental issues:

Hackathon Ideas


Day in day out Countries in Africa and other parts of the world keep on facing environmental issues, and if you can use Technology to solve this issue it will be a very good idea for the Hackathon event.

Idea:


What about creating an app that can help to spread information about Environmental issues and how to solve them?

This app won't just tell you what to do but will also help you accomplish them.

For example, you could program the app to send a message to the Pick up Dirt Truck station  at the end of each week to retrieve the waste without even bothering yourself.

It could also set you a reminder to clean your Environment every sanitation day.

Having great ideas like this can help you win the Hackathon Event.

Health:

    Hackathon Ideas


I call this the In demand of the world right now, we all know how quality of health is dropping day by day, a lot of research has been done they have found the causes of these health issues.

Alot of Resources has been invested into Health Care in the United States

  Read more: You can now get Prescriptions without going to an Optician


Will there be any bad if you try your best to find out the solutions from these causes, of course not you could win with this Hackathon idea.


Idea


Building an app that you can input the symptoms of your illness, and then get the suspected disease of ailment which should be accurate


The drugs to be taken is also recommended in the app as well, instructions should be left for the pharmacist or Doctor to see while taken to the hospital, although this relieve the doctor of minor work but it saves time


Exercise

       Hackathon Ideas


I'll admit it, taking exercise is hard for some people especially when it's hard for you to track your progress, some phone producers like Samsung have includes the Calories Burning tracker in their phones.

An idea can be crafted by you to bring about Great results maybe an app that tracks the distance you've covered while walking, you can set a goal and that helps you to walk more and burn more calories.

Music:

Hackathon Ideas







Music is passionately one of the things I personally love, and I feel over the years it has improved because of technology.

You could make it better if you have a great Hackathon idea for music, who knows? You can win it

Ideas


Having an app that records and fine tune all audio recording while singing, rather than going to a studio and spend more money,

Having such app can help as its cost efficient and also it is more convenient and less stressful to carry out.

It seems like a big deal but the truth is it could be just another idea the world will love.

Agriculture:


We know a century ago people were more inclined to Agric, but now it's not the same it's just so boring just like education and young ones are not attracted to it at all...

What attracts these young ones is the computerized life, so what if Agriculture was computerized all through out?

You could figure out a great idea from that and even grow it into a worldwide practice it will be a great Hackathon idea only if you can develop on it.

General Issues:


There are some issues that just doesn't seem categorized you could find solution to them as well , irrespective of what they are there are always solutions when we try harder to find them.

Conclusion:

I've never gone for Hackathon before but I'll admit having your Hackathon ideas is pretty much as having your trophy; you just have to build on it and let it grow

Hackathon ideas are at your hands now go take that Trophy!