Woo-Hoo! Look What I Just Did With Charts By Using The AR Search Feature!

By
Real Estate Agent with RE/MAX Shoreline - NH and Maine NH and Maine Broker


OK, I admit I am not the most adept when it comes to software like Excel, but one of my sister's (Karen - for those of you who've met her) is awesome at teaching herself all kinds of stuff when it comes to technology, and I knew she knew how to do charts and graphs.  And I wanted some of my own!

Karen and I spent a couple of hours on the phone, actually on Skype (it's FREE!), trying to get me up to speed, (okay kindergarten speed) on Excel so I could at least do the very basics for the types of charts or graphs that I'd like for some of my market reports.  She's so patient, and sometimes I am and sometimes I'm not, but we finally got to where I could do and create the basics for what I want.  And then I tinkered around and added color, changed some stuff up, etc.  Now, how to get them into my posts - we just could not figure that part out, no matter what we did!  U-G-H.........

Gena Riede - Sacramento Real Estate Sales

I had read Gena Riede's post on the latest market information on Sacramento real estate, and loved how her graphs looked.  I asked her how she made hers, and how she got them into her posts.  I didn't know how to do what she emailed me as her steps to getting those beautiful charts into her post, so I kept thinking.



And my thinking led me to remember to use the "Search" feature here on AR. 


A little while back, I had read a post that Elizabeth Nieves had written and I thought she mentioned ScreenHunter, and downloaded that program right after reading her post.  But I couldn't figure out how to make it work like she had done.  And out of frustration, I was going to just delete it off my computer, but hadn't gotten around to it just yet.  If it wasn't something I picked up from Elizabeth, my apologies to whoever it was - I just tried to find the post or comment in a post where I learned about this, and I can't find it to link to.

Richard Dolbeare - Kauai Real Estate

So, back to the AR "Search" feature - I typed in 'excel charts in posts', and got a slew of links that came up.  Most of them weren't about what I wanted, but there were a few in there.  I did read and watch Jeff Turner's tutorial post on charts, using google charts, but I wanted to use the charts I'd already created with my sister in Excel. 

I kept reading, and found posts by Richard Dolbeare on Excel charts and some really cool things you can do with them, but I still wasn't seeing HOW to get them into a format that I could insert into my posts.  His posts on advanced excel charts are great reading for really making your charts and graphs look really cool, so check them out.


More reading....and then I found Joe Manausa's post, "How to Make Market Graphs for Your Blog".  Joe's got detailed steps in a video he put together on this post.  Most of that info included the steps I'd already done, and then towards the end he told how to get them into .jpg format.  And guess what??  He uses the program above that I was just about to delete - ScreenHunter!  I watched that part in detail, and then went to my desktop, and opened ScreenHunter up, and just stared at it again, still clueless.  But I was a little more determined this time around, and through their 'help' section, I finally GOT IT!!

           Rye NH Homes - Activity for 2008 - Copyright Ann Cummings NH REALTOR


I can see I still need to tinker with ScreenHunter to get better with it, but I am psyched to know I can now get charts and graphs into my posts - FINALLY!!

So, thanks for all the sharing that goes on in so many posts and comments.  If you're looking for some information, make sure to use the "Search" feature here on AR - you're sure to find exactly what you're looking for.  I certainly did!

                    Search New Hampshire and Maine Homes Condos For Sale   Portsmouth NH Homes - Portsmouth NH Area Real Estate Market Reports
          Contact Ann Cummings New Hampshire REALTORNH and Maine Real Estate - Featured ListingsRead My Newsletter

                    Ann Cummings New Hampshire REALTOR     Follow Ann Cummings on Twitter!


Ann Cummings, New Hampshire REALTOR
RE/MAX Coast to Coast
Portsmouth NH
ann@anncummings.com
888-349-5678x 3839
Servicing the Coastal Areas of NH & Southern Maine     
New Hampshire and Maine Real Estate

 

 

Posted by

Ann CummingsREALTOR, e-PRO, GRI, CBR

Ann Cummings and Jim Lee formed a team in July of 2010.
Each bring over 30 years of successful real estate experience to the table so with Ann and Jim you truly do get two Realtors for the price of one. We’re dedicated to delivering exceptional service to you our clients and customers; past, present, and future.

Jim LeeCRS, ABR, GRI, e-PRO

close

Re-Blogged 3 times:

Re-Blogged By Re-Blogged At
  1. . 4Terra Land Brokers .. 828-776-0779 Asheville NC 01/11/2009 05:09 AM
  2. Renée Donohue~Home Photography 04/15/2009 01:41 PM
  3. Cheryl Ritchie 04/24/2010 11:07 AM
Topic:
ActiveRain Community
Groups:
Tech Corner
The Art Of Marketing You
$100 or 100 minutes, Techy time savers!
It's all about them (ThemThem)
The Ninety-ninth Percentile
Tags:
jeff turner
gena riede
richard dolbeare
elizabeth nieves
excel charts graphs

Post a Comment
Spam prevention
Spam prevention
Show All Comments
Rainmaker
340,012
Ann Cummings
RE/MAX Shoreline - NH and Maine - Portsmouth, NH
Portsmouth NH Real Estate Preferrable Agent

Hi Carole - not too late at all!  And thanks!

Hey Renee - thanks for those links - your charts are BEAUTIFUL!!!  You may just have to tell me how to do that for my charts.  That's my next learning step in this chart-learning process I started.  Really great-looking on your posts!

Hi Jennifer - I hope ScreenHunter helps you out.  Someone else mentioned using Google docs in their comment, too - will have to check that out to see what I can do with it.



For those interested in the charts with pictures as the backdrops - go check out Renee's newest market reports - the links are in her comment above.  She did a GREAT job with those!!!   

Jan 12, 2009 10:01 PM #91
Rainmaker
60,594
Jodi Bakst
Team Jodi Realty - Chapel Hill, NC
Team Jodi - Chapel Hill Real Estate, Durham Real E

Ann,

Thank you for doing this comprehensive research.  I have been doing something completely different that works but I think what you did looks even better.  I have bookmarked the post and will come back to it later.

Jan 14, 2009 08:59 AM #92
Rainer
292,552
Diane Aurit
LKN Realty, LLC - Mooresville, NC
Lake Norman Real Estate

Ann, great job!  We forget sometimes how much incredible information is right here on AR.  What an awesome group we are, thanks for sharing your story!

Jan 14, 2009 09:55 AM #93
Rainmaker
340,012
Ann Cummings
RE/MAX Shoreline - NH and Maine - Portsmouth, NH
Portsmouth NH Real Estate Preferrable Agent

Hi Jodi - I'd love to hear what you're doing, if you feel like sharing.  I'm always open to new ideas and ways to do things.

Hi Diane - there is such a wealth of information here on AR!  We just have to look for it, sometimes it's right there in front of us and other times we just have to look just a little bit and there it is, like this info on doing charts.


Thanks for reading and commenting!
Ann

Jan 14, 2009 11:29 AM #94
Rainer
208,371
James Wexler
wexzilla.com - Scottsdale, AZ

this is a very cool presentation, what a great way to present some easy to understand market stats to your clients

Jan 17, 2009 02:44 AM #95
Ambassador
1,090,772
Celeste "SALLY" Cheeseman
Liberty Homes - Mililani, HI
(RA) AHWD CRS ePRO OAHU HAWAII REAL ESTATE

This is great...I think I'll just jump on this bandwagon the next time I add some stats to my local area posts! You see..you always have something great you enhance yours with ..thanks Ann!

Jan 18, 2009 01:43 PM #96
Rainmaker
340,012
Ann Cummings
RE/MAX Shoreline - NH and Maine - Portsmouth, NH
Portsmouth NH Real Estate Preferrable Agent

Hi James - thanks!  I learn so much from so many here on AR, that the few times I have something cool to share like this I just can't help but put it out there for others to learn about it, too.

Hi Sally - I've got some nice charts done all ready for posts.  Now, I just have to write the posts!  ;-)


Thanks for commenting!
Ann

Jan 21, 2009 10:33 AM #97
Rainmaker
467,265
Midori Miller
Talk 2 Midori, LLC - Daytona Beach, FL
Online Marketing For Real Estate Professionals

Ann-this is awesome..I'm lousy on excel..I admit..its funny a lot of times when I need to figure out something I type it in the search here and usually find what I am looking for!  I bookmarked this! 

I hope you are staying warm..its was nice today..I actually left the house without my gloves and jacket!

p.s  I am going to be taking a class in excel in the next few days!

Jan 26, 2009 11:37 AM #98
Rainmaker
1,036,503
Kathy Clulow
RE/MAX All-Stars Realty Inc. Brokerage - Uxbridge, ON
Trusted For Experience - Respected For Results

Ann - Once again the rainmakers come through for a member, a true testimonial as to just one of the value added features of being a member.

Jan 27, 2009 11:13 PM #99
Rainmaker
340,012
Ann Cummings
RE/MAX Shoreline - NH and Maine - Portsmouth, NH
Portsmouth NH Real Estate Preferrable Agent

Hey Midori - I would love to be sitting there with you in that excel class!  Take good notes so you can give me some pointers to learn more about it.  My sister, Karen, who helped with me this, loves that program.  No leaving my house today without gloves and a jacket - snowy and chilly!

Hi Kathy - you're exactly right - so much value in all there is here for us as members!


Ann

Jan 28, 2009 09:27 AM #100
Rainmaker
655,882
Bob & Carolin Benjamin
Benjamin Realty LLC - Gold Canyon, AZ
East Phoenix Arizona Homes

Good information. Thanks for sharing with us all -- all the best.

Feb 03, 2009 02:49 PM #101
Rainer
132,319
Jon Wnoroski
America's 1st Choice RH Realty Co., Inc. - Green, OH
Summit County Realtor

Hi Ann - Great post and some really good research.  I've used excel to create grafts but am not pleased as to how they look in posts.  I'll explore some of these features to see if I can come up with a graphic that will look good in a post.

Feb 10, 2009 11:14 PM #102
Rainer
116,372
Sue Berger
Gladwin, MI
Gladwin MI

Thanks Ann for your determination and thoroughness.  I'm bookmarking your blog for future reference and will check out ScreenHunter.  Great post!

Feb 13, 2009 03:23 AM #103
Rainmaker
578,649
Pat Starnes-Front Gate Realty
Front Gate Real Estate - Brandon, MS
601-991-2900 Office; 601-278-4513 Cell

EXACTLY what I've been looking for. Thanks for doing all the research. Bookmarked!

Feb 18, 2009 04:49 PM #104
Rainmaker
340,012
Ann Cummings
RE/MAX Shoreline - NH and Maine - Portsmouth, NH
Portsmouth NH Real Estate Preferrable Agent

Hi Bob and Carolin - you're welcome!

Hi Jon - hopefully some of this info will help you do what you're looking to do.  I was so happy to finally be able to do some charts like I'd seen others do.  And when I have a chance, I'm going to figure out how to add pictures in the background so I can be as cool as Richard!  ;-)

Hi Sue - I've used Screenhunter a number of times since this post and love it! 

Hi Pat - glad to know my digging helped others!


Thanks for reading and commenting!
Ann

Feb 24, 2009 11:33 AM #105
Rainmaker
394,850
Elizabeth Cooper-Golden
Huntsville Alabama Real Estate, (@ Homes Realty Group) - Huntsville, AL
Huntsville AL MLS

Ann, So I'm a bit late to the party here....GREAT stuff!  I always have my husband make my charts and I need to learn how to do this myself. I"m bookmarking this.  Thanks for the great info Ann :)

Feb 25, 2009 03:38 AM #106
Rainmaker
921,236
Ginger Harper
Coldwell Banker Sea Coast Advantage - Southport, NC
Your Southport~Oak Island Agent~Brunswick County!

Thanks so much.  I will try this.

Ginger

Apr 04, 2009 06:33 AM #107
Ambassador
1,509,132
Renée Donohue~Home Photography
Savvy Home Pix - Allegan, MI
Western Michigan Real Estate Photographer

FYI I am one of the people that re-blogged this since I have people asking me what I do every time I post a graph, LOL!

Apr 15, 2009 01:44 PM #108
Rainmaker
558,307
Maggie Dokic | Miami, FL | 305.81.HOUSE (46873)
eXp Realty LLC - Miami, FL
GREEN, CDPE, SFR, Pinecrest | Palmetto Bay |

Ann, I love being able to go back to useful posts and using them all over again.  Thanks again.!

Sep 03, 2009 09:34 PM #109
Rainmaker
1,364,196
Cheryl Ritchie
RE/MAX Leading Edge www.GoldenResults.com - Huntingtown, MD
Southern Maryland 301-980-7566

I use Snagit but yours is free! I like Snagit to do a lot of copy and paste items for Top Producer 8i CMA.

Apr 24, 2010 11:14 AM #110
Post a Comment
Spam prevention
Show All Comments

What's the reason you're reporting this blog entry?

Are you sure you want to report this blog entry as spam?

Rainmaker
340,012

Ann Cummings

Portsmouth NH Real Estate Preferrable Agent
Ask me a question
*
*
*
*
Spam prevention

Additional Information