Hawaii Real Estate Resource

head_left_image

How to copy an Excel chart to an image file

OK, you've worked hard and come up with a wonderful Excel chart that you would like to include in a presentation document.  But how do you copy it to an image file?  There is a hidden pearl that allows you to do exactly that.  Hold down the CTRL and Shift keys simultaneously while you select the "Edit" menu item with your mouse.  Edit will contain a "Copy Picture" item that is otherwise not present (see image below).  Copy it and paste into your favorite image program, MS Word, or Powerpoint.  Have fun!

 

Here is the resulting image (reduced in size for this blog).


Visit www.KauaiRocks.com


Richard Dolbeare, REALTOR-ASSOCIATE
Richard Dolbeare
REALTOR-ASSOCIATE®
Accredited Buyer Representative & e-PRO
Century 21 All Islands, the #1 brokerage on Kauai
(808) 651-4550
(866) 757-8239 (FAX)
email address

Richard T. Dolbeare, R(B) photo

 

Richard T. Dolbeare, R(B)

Keller Williams Realty(808) 651-4550

Aloha@RichardDolbeare.com 

www.MauiSandCastles.com and www.KauaiRocks.com 

 Hawaii multi-island specialist, Maui & Kauai
Richard Dolbeare eBusiness Card

Google+ Twitter icon Facebook logo Youtube logo

Comment balloon 22 commentsRichard T. Dolbeare • June 15 2007 04:57AM

Comments

Good information.  Thanks for sharing it.  I usually use a dump screen command to get a jpg from whatever I working on.
Posted by 1 ~Judi & Don Barrett & Chassy Eastep - Integrity, BS Ed, Integrity Real Estate Services -IDABEL OK (Integrity Real Estate Services 118 SE AVE N, Idabel, OK 74745) almost 12 years ago
I like the creativity of the photo as a backdrop to the chart. Nicely done! I think I need more practice using excel to perfect it!
Posted by Allison Stewart, St. Cloud Fl Realtor, Osceola County Real Estate 407-616-9904 (St.Cloud Homes ) almost 12 years ago
I love using hidden tools like this.  Every once in a while I stumble onto one, but I prefer having YOU just tell me.  :)
Posted by Chris Griffith, Bonita Springs Listing Agent (Downing-Frye Realty, Bonita Springs, FL) almost 12 years ago
 Hey, thanks for the tip.  I was aware of being able to "copy picture" and upload an excel as a picture for a web image, but I love the backdrop photo idea.  Thanks so much.  
Posted by Lea Deo - REALTOR®, Johnson County REALTOR®| Shawnee KS Homes for Sale (Keller Williams Legacy Partners, Inc.) almost 12 years ago
Just yesterday, I was trying to turn an Excel table into a jpg file so I could use it in my outside blog. I use Excel a lot - and have for over 15 yrs - but was unaware of this. I'll give it a try to see if it does what I want to do. Thanks for sharing this.
Posted by Elaine Reese, REALTOR® in central Ohio (Real Living HER, Powell Ohio) almost 12 years ago

Richard.....  this is some great information, thanks for sharing this.

                                                                                                          jeff belonger

Posted by Jeff Belonger, The FHA Expert - FHA Loans - FHA mortgages - USDA loans - VA Loans ( Social Media - Infinity Home Mortgage Company, Inc) almost 12 years ago
That is a great little tip.  I just tried it out.  I wonder why that one only works with the key combination. It will definitely get some use.  Mahalo!
Posted by Randy Prothero, Hawaii REALTOR, (808) 384-5645 (eXp Realty) almost 12 years ago

Great info, I would have done it the 'long way'

 

Posted by Tom Burris, Texas/Louisiana Mortgage Pro - 13 YRS Experience (NMLS# 335055) almost 12 years ago

Thanks for the tip. I had been using Print Screen, but this is much better.

 

Posted by Leon Austin, Colorado Springs Mobile Notary (Mobile Notary Services) almost 12 years ago

I have been using the Excel copy image feature for a long time and have found it to be much easier and higher quality than the print screen method.  I don't know why this feature is not better publicized because it's quite valuable to those of us who use chart images in presentations and websites.

I also had a request to describe how to implement the background picture which I will cover in a separate posting soon.  Of course you must travel to Hawaii to take a photo like that <grin>.

Aloha

Excel chart image from copy image feature

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
You have no idea how much time I've spent trying to do this very thing.  You are my hero.  Thanks.
Posted by Kay Van Kampen, Realtor®, Springfield Mo Real Estate (RE/MAX Broker, RE/MAX) almost 12 years ago

You're welcome Kay.  Now if only I can figure out how you accumulated all those Activerain points, obviously I have lots to learn!  BTW, I spent some time in the Ozarks as a kid and it's a great place.

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
Richard - All I can see on my screen is the dreaded broken link red "X".  Can you tell me why?  I loved your post and want to do this as I am a faithful Excel spreadsheet afficianado.  Thanks!  Never mind - As soon as I posted this comment, the screen showed your charts.  Wow!  Can't wait to do this!
Posted by Marlene Bridges, Laguna Homes|Laguna Condos|Laguna Real Estate (Village Real Estate Services, Inc.) almost 12 years ago
This is wonderful that you have shared this.  I wish I had seen this the other day so I could have avoided the headache I ended up with..
Posted by Lisa Spruck (Monarch Business Solutions, Inc) almost 12 years ago
It's a hidden pearl in Excel.  It seems strange that it's not more visible.
Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) almost 12 years ago
Thanks for sharing your knowledge of excel. Great Post.
Posted by Frank Rubi, FrankRubiRealEstate.com (Frank Rubi Real Estate, LLC) almost 12 years ago

WHat a time saver...and I thought I knew excel. 

Posted by Bob Carney, Licensed MD/PA Real Estate Agent (Taylor-Made Deep Creek Vacations & Sales) almost 12 years ago

Hi Richard - I can see how to copy the picture and put it into a word doc, but how do I get that chart into my AR posts here?  I can't seem to manage to get that done, no matter what I try.  Is there any way to save an excel chart as a .jpg or some kind of image to insert it here?

Many thanks for your help.
Ann

Posted by Ann Cummings, Portsmouth NH Real Estate Preferrable Agent (RE/MAX Shoreline - NH and Maine) over 10 years ago

Hi Ann - If you followed the directions herein and were successful at pasting it into a Word doc, then you're almost there.  Instead of pasting into Word, past it into an image editing program and then save it as a jpg file.  You can use the dreaded Microsoft Paint which is a Windows freebie or you can use something else such as IRFanView which is a freebie download.  I think you will love IRFanView if you try it but that is another post.

Anyway, once you have saved it somewhere as a jpg file, then you must upload that to one of your websites and then use the ActiveRain "insert/edit image" to add it to your post.  If any of these steps are confusing, send me another question.

Since this post, Microsoft has released Office 2007 which does not have the copy feature I described in this post.  If you use Office 2007, just click on your chart to select it and then right click and select "copy". 

Aloha & happy posting.

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) over 10 years ago

Hi Richard - thanks for that detailed explanation.  I did, FINALLY, get it all together, and I mentioned your posts in the one I just put up thanking everyone for their very helpful posts, and I used one of your graphs in my post.

Here's the link to my post --> Look What I Just Did By Using the AR Search Feature!

Thanks again for your help!
Ann

Posted by Ann Cummings, Portsmouth NH Real Estate Preferrable Agent (RE/MAX Shoreline - NH and Maine) over 10 years ago

Thanks goodness for ActiveRain tutorials and blog posts like these.  I really do appreciate it, now if someone would only email me some time...then I could get all of this done ;-)

Posted by Tamara Inzunza, Close-In Alexandria and Arlington Living (RE/MAX Executives) over 9 years ago

Ann-I DID check out your charts and they look good.  Thanks for the mention.

Tamara- Hi again.  I'm a little short of spare time these days but if I get any I'll be sure to email it to you :-)

Posted by Richard T. Dolbeare, R(B), ABR, CRS...Hawaii Multi-Island Specialist (Keller Williams Realty Maui) over 9 years ago

This blog does not allow anonymous comments