I have been asked over and over again how I do my graphs in my market reports. It was too hard to type out instructions, so I found a better way to show you.

I'll just show you what I do.

A few things to remember, I use Microsoft Excel 2003, if you have a newer version it may look different, but it will probably work very close to the same.

For some reason, I cannot paste the clip using windows explorer in the location where I am going to save it as a jpg. I use my pictures program called ACDSee, you can probably use any pictures program to save your finial product.

Have fun! It really is easy to do. And please forgive the rather amateur video production of mine. It was the first time I have done anything like it, but it was a bit fun I have to say.



Swiedler, Pomerantz &Adams, the Luxury SPA Real Estate Treatment!Swiedler Pomerantz Adams

Search homes for sale Litchfield CountySearching for a home? We have an app for that!
Text GLR to 87778
for your free app to search homes for sale right from your cell!

Search homes for sale in Litchfield County, CT.

Selling your home? Check our powerful marketing system.

New Milford CT Real Estate on FacebookAndrea Swiedler on LinkedinNew Milford CT Real Estate on TwitterGoogle

Prudential Connecticut Realty, New Milford & Litchfield, CT

Prudential Connecticut Realty is a wholly owned subsidary of HomeServices,

a Berkshire Hathaway Affiliate

© Swiedler, Pomerantz & Adams, 2009 - 2012

 Always do right. This will gratify some people and astonish the rest. - Mark Twain

 
Post is included in group: "Whacked"!!!
Post is included in group: Cosmic Cow Pie...The Rome Way
Post is included in group: Connecticut Professionals
Post is included in group: POSITIVE ATTITUDE for the Weary Soul
Post is included in group: BananaTude

126 Comments on I'm giving away the secret to my graph making, for free!

20 Most Recent Comments Displayed Show All

SEP
04
 Thanks for sharing!! This will be put to good use.
7:56pm • #108
264,357 Points 3 Featured Posts Outside Blog Attended Rain Camp

Great information, Andrea. Thank you for making it available to our community. It is part of what I enjoy about Active Rain…the willingness of members to share.
8:05pm • #109
264,405 Points 1 Featured Post Outside Blog Called Shot Master

Nicely done. I did not know you could do that with Excel. Of course now that I know that, it will take me a while to actually make it work!
8:18pm • #110
1,582,986 Points 429 Featured Posts Outside Blog Attended Rain Camp Called Shot Master

THanks for a great tutorial, Andrea. You've made it look so easy. I do a lot with excel except for graphs so I'm pleased to have learned another feature that has applicability! I think there are others here on AR who use it as well.

Jeff
8:30pm • #111
515,484 Points 5 Featured Posts Outside Blog Called Shot Master

Very nicely done Andrea and great information!!!  Thanks so much for sharing!
9:03pm • #112
3 Featured Posts Outside Blog

Very nice job on video with your tutorial.  Many people do a far more confusing job on easier topics.  I can't wait to try this.  :)
9:50pm • #113
SEP
05
123,679 Points 2 Featured Posts Outside Blog

Thank you for taking the time to show us!
6:20am • #114
495,537 Points 13 Featured Posts Outside Blog Called Shot Master

Hi Andrea, we do something similar but copy and paste into Publisher and save as a jpg.
10:35am • #115
Localism Sponsor Outside Blog

Great screencast Andrea! Providing visual info really keeps the readers interested.
10:56am • #116
2 Featured Posts Outside Blog

Andrea, thank you so much for taking the time to do this video and share with us how you do graphs in Excel. I can't wait to plug my own data in and make it work. I appreciate it!
12:45pm • #117
1,022,995 Points 15 Featured Posts Localism Sponsor Outside Blog Called Shot Master

I use Open Office - because I am cheap and it is free.  It works like office and I will play around to see if I can do better graphs.  I use the Snipping Tool that came with the computer to get a JPG of the graph.

Thanks for the great post.
4:35pm • #118
SEP
06
301,096 Points 27 Featured Posts Outside Blog Called Shot Master

This is fantastic thank you so much for sharing it with us... Beth
7:52am • #119
SEP
07

AWESOME!

I was recently thinking about taking an online class to learn how to do graphs and a few other things in excel. Well forget that! You just showed me. I generally learn all software by playing around and teaching myself, but just haven't had the time to investigate excel more. Thank you so much!!!
9:53am • #120
697,950 Points 15 Featured Posts Outside Blog Called Shot Master

Thanks, Andrea.  You just took the reason I don't do these out of the equation!
11:34am • #121
547,229 Points 9 Featured Posts Outside Blog Called Shot Master

Andrea:

Please give us more instructional videos.  I think you have future there.  You instructions are so clear and and easy to understand anyone can create good looking charts.  Thanks
1:34pm • #122
SEP
09
117,733 Points 1 Featured Post

Hi Andrea,

Thanks for sharing, have bookedmarked to use in the new future.
8:02am • #123
774,383 Points 16 Featured Posts Outside Blog Attended Rain Camp Called Shot Master

Andrea, I just stopped by via Evelyn Kennedy's reblog of this post and have bookmarked it.  This does take a little of the mystery out of Excell and making graphs.
1:07pm • #124
SEP
13
811,245 Points 163 Featured Posts Localism Sponsor Outside Blog Called Shot Master

Wow, thanks everyone! Hope you were able to put this to some use for yourselves. Happy Graph-ing!
1:05pm • #125
SEP
18
237,585 Points 2 Featured Posts Outside Blog Attended Rain Camp

Thanks Andrea, I get my charts directly from my MLS provider, but I never knew that you could insert a graphic behind the chart in Excel.  Thanks for the tip!
7:53pm • #126
JAN
03
1,151,939 Points 86 Featured Posts Outside Blog Attended Rain Camp Called Shot Master

Just came back to this so I can try something thanks again
6:24pm • #127

20 Most Recent Comments Displayed Show All

Login or register to leave a comment
 
Andrea%205%201%20hd%202 Ambassador_large

Andrea Swiedler - Swiedler, Pomerantz & Adams, Litchfield County Real Estate

New Milford, CT

More about me…

Prudential Connecticut Realty, Litchfield County Real Estate

Address: 27 Main St, New Milford, CT, 06776

Office Phone: (860) 355-2646 x 19

Cell Phone: (203) 460-1775

Email Me

Real estate and local area information for New Milford, Brookfield, Sherman, Roxbury, Bridgewater, Kent, Warren, Washington, Morris, Bethlehem, Litchfield, Goshen, Woodbury, Cornwall, West Cornwall, Cornwall Bridge, Connecticut
Swiedler_Pomerantz_Adams
SEARCH THE MLS LIKE A REALTOR







Locations of visitors to this page \


Listings

Links

Archives

RSS 2.0 Feed for this blog