Home : Blogs : Joe Manausa - Tallahassee Real Estate : Tallahassee Real Estate

How To Make Market Graphs For Your Blog

This is long over due. Ever since I posted a blog on how to use Microsoft Excel to create market graphs, I have been thinking about doing an instructional video for Active Rain members. Finally, I have it posted!

If you have been wondering if you could be posting useful charts and graphs in a real estate blog, you can! Here is all you need to know about creating simple charts using Microsoft Excel. Watch the video and let me know what you think!

If you would like to see examples of real estate market graphs or if you want some ideas for market report schedules, please drop on by.

How To Create Real Estate Market Graphs

As a reminder for those who subscribe to the Tallahassee Real Estate Blog by email, some embedded pictures and videos might not be appearing in your email and you might need to click the title header to go to your browser where all will be visible.

Keep checking out the Tallahassee Real Estate Blog every day for updates that include charts, graphs, and analysis of the Tallahassee real estate market.

If you like this Article then please subscribe to my blog through a full RSS feed, or you can . You will be able to stay informed about the happenings in the Tallahassee Real Estate Market. You can also subscribe to this blog and have it delivered by Email.

Joe Manausa is a real estate investor and the Broker and Co-Owner of Century 21 First Realty. He can be reached via e-mail through the Tallahassee Real Estate Website or catch his latest writings on the Tallahassee Florida Real Estate Blog , or by calling (850) 386-2001.

Posted by Joe Manausa - Tallahassee Real Estate on 07/20/2008 01:24 PM

Comments (66)

realestatecharts, realestategraphs, how to make excel charts, help, faq, tutorial, howto

Originally posted at: "Singing in the Rain!": How To Make Market Graphs For Your Blog

Post is included in group: Realtors®
Post is included in group: The Lounge at Active Rain
Post is included in group: Dedicated Bloggers
Post is included in group: HELP/FAQ (Read 'Purpose Statement' Carefully!)
Post is included in group: Market Reports

66 Comments on How To Make Market Graphs For Your Blog

JUL

2008

Joe, Great video and tutorial on making market graphes. I had to book mark this one. Good job.

Thanks Jimmy. Let me know when you've posted some market graphs so I can compare notes.

Thanks you for your post. I like using excel and enjoyed watching your tutorial.

Thanks Jon. Like Jimmy, let me know if you post some market graphs so we can compare notes.

Great tutorial, Joe! Graphs are a great way to get boring statistics into graphics that are appealing, interesting and more understandable!

Thanks again!

Thanks Leesa, I think so too! I think it helps to see a "picture" rather than just numbers.

JUL

2008

Joe - this is a well done and informative post. I have bookmarked it to use later.

Thanks Christine, I'm glad you liked it. Let me know when you publish some good market graphs.

Joe- Awesome! That is by far the best blog of yours I have read, watched, tasted - of all youro blogs! Now I'll have to figure out something to Chart and graph to try out this tool! Well done!!!

Thanks Eva. I'm just starting to learn how to embed video...

Great stuff Joe. Love the video work and the straightforward demonstration of excel.

We often want to convey important information to our clients and don't know how to explain it.... sure graphs help and yours look great! Finally, thanks to your tutorial, we can create our own! Thanks Joe!

Very well done, Joe!

Thanks Joe, just trying to figure the video stuff out right now.

Thanks Carol.

JUL

2008

Joe - bookmarked, so I can come back when needed. I was looking for this info for a while now. You made it easy. Thanks.

Thanks Josh, I'm glad you liked it.

I'm glad you liked it Petra.

Interesting. I appreciated the video. Looks like it was done with an Apple computer.

I havent finished looking at this one. But I am definitely going to come back to it later to finish watching the rest of this video. Thanks for sharing.

JUL

2008

Hey Kevin, nope, done on a good old HP (Dell actually).

Joe: Great tutorial and I've been using excel that way but some of things you mentioned will help me make creating charts a bit smoother. Also, for really simple charts, have you heard of google.docs There's a great post by AR member, Jeff Turner about this.

Thanks Lanre. I'd love any feedback and I'd also like to see your market charts when posted.

Thanks Donna. I'll have to check out Jeff's blog.

Excel 2007 really has some easy to use features to produce great results. Haven't taken a look at pivot tables yet, and definitely need to work on creating some graph styles. Thanks for the reminder, Joe!

It's definitely a tool we should all be using John. Rarely a day goes by that I don't fire up Excel.

JUL

2008

Hey Joe, Thank you so much for taking your time and creating this tutorial. I am book marking this one.

JUL

2008

Joe - I learned a few things - thanks - now I gotta practice some - you did a great job - thanks for sharing!

JUL

2008

Thanks Teresa, I'm glad you liked it.

Thanks Cyndee, I'm glad you liked it.

this is DEFINATELY going in the book mark. thank you very much for posting this!

Thanks Dee, I'm glad you liked it.

OCT

2008

I am impressed with this site.It's nice.I have similar thing i am dealing with.
My aim is to share any type of information with all of you.If i have
done any mistake please excuse me.

=============================================

JOHN ROBERT

Thanks John.

OCT

2008

I oversee 7 real estate offices and provide our agents with a broad range of statistics and graphs so I wanted to suggest a great site for making fantastic "totally free" graphs of any data you might put together http://nces.ed.gov/nceskids/createagraph/default.aspx

You can export in various formats but the most useful is the SVG export option for those of you with Adobe Illustrator experience you will be able to open the SVG in Illustrator and manipulate each and every part of the charts, graphs and data to look exactly as you want it.

Mark Passerby
www.PovVideotours.com

OCT

2008

I liked your video! I also use the Jing capture tool for video and picutures. It is also free at http://www.jingproject.com. I have posted some similar ideas on my AR blog - but I think I need to upgrade to Excel 2007! I am using 2003 and it doesn't seem to have as many cool tools as your video showed!

I would love to be a part of your network on LinkedIn. Add me: nathankerpan@usgdirect.com

It would not let me send you an invite. http://www.NathanKerpan.com

Thanks Joe. One thing about Active Rain, when you have a question someone always manages to write a post with the answer. I have been admiring market reports with graphs for some time now but haven't know how to do one. Thanks for filling me in.

What a great post! I too have bookmarked (Google Bookmarks) it. I was a bog user of snagit for my screen capture needs on my old XP laptop. When I got this Vista laptop I didn't now what to use, but somehow (probably thanks to google again) I discovered that Vista has a built in screen capture program. It is called the "Snipping Tool" and you can fnd it by typing that into Search box insiude the Start menu.

Once again great post Joe!

For Screen Capture I have always just used the "Print Screen" key next to the F12 then click that button then Open Adobe Photoshop or Photoshop Elements or most any other photo edit program. In you photo edit program click "File" "New" then click "ctrl" and "v" and the screenshot is now pasted into your photo edit program where you can crop, save etc.

Mark Passerby, POVvideotours.com

OCT

2008

I find this tutorial wonderful, and I have never actually used the pivot table.

Joe, thanks so much for putting together this tutorial. I must say you are definitely comfortable with Excel. I hate it. Anyway, I will get going on this because the graphs look absolutely great. The wow factor I think over other agents when you post this for your area.

I have over 256 dates and it will not let me group them by date. It just says it cannot group for the date field. Any help you can offer? Thanks Patrick Milligan

Joe, What program did you use to create the You Tube video? I thought that was the most amazing part, aside from the valuable info on creating a market graph. It looked like a combination of PowerPoint with embedded videos.

Patrick Milligan - if you cannot group in the Pivot Table - you have a blank somewhere in your data. I have found that if I have any blank cells anywhere in the data - this will cause the error you described. Richard Ferris, AmcAppraisalsinc.com Fl St Cert REA #RD4088

OCT

2008

I have always wanted to know how to make market graphs for my Washington DC Market reports. I am definitely going to check this out. Have a great weekend. Great post.

Hi Joe, I did make a neat graph from your instructions in your previous post, but I couldn't remember later how I did it. I have bookmarked this post and will use it frequently, I'm sure! Thank you for this.

OCT

2008

Joe, Really great presentation ... thank you!! MS Excel offers so much, but can be so confusing to figure out. You've just demystified a great feature. Also, thanks for sharing the "Screen hunter" software info. I use to use "Snag It," but I need to reinstall my computer, so I'll give your recommendation a try. Best regards, Mike

Hi Joe - just found this post, and watched your video. I know nothing about excel and this is a bit over my head at this point. We can't, not that I know of, download data like you show in this video. We have to get the data manually and then create charts. I'd love to be able to know how to create charts from scratch in exel......one day maybe I will.

Ann

This is great information. We are looking at creating a "Market Trends" newsletter and this will be very helpful. Thanks,

OCT

2008

Thanks for the feedback Ann. I bet you can find a techie who can show you how to capture your market data though!

JAN

Joe, I missed this the first time and just read about it on Ann Cummings post - so wanted to say thanks!

I'm glad you found it (and liked it) Jo!

JAN

This is what I was looking for, thanks for your time in putting together the tutorial! One (unrelated) question - would you mind sharing how you made/where you got the "buttons" at the bottom of your post (with link to your market reports, etc.) I've googed 'custom buttons', etc but don't see anything. Thanks!

Thank Kevin. I find that making something in MS Powerpoint and then doing a screen capture to convert it to a .jpg or .gif file is the easiest way to make buttons.

JAN

Joe - Thanks for the suggestion! I hadn't thought about that solution. Great idea.

JAN

No problem Kevin. There are probably other great ways, this one just is simple.

FEB

Hi Joe,

Your blog was one of my first learning experiences on Active Rain, and it made an impact on me. I relly enjoyed it. Here is how I recently employed some of the techniques you discussed on screen saving.:http://activerain.com/blogsview/910639/How-productive-is-your-BLOG-in-driving-traffic-to-your-website

Best regards,

Mike Andruff

Thank you Mike. I went and checked out your blog and your results are outstanding. Keep up the great work!

FEB

This one will take me a few tries to master.

FEB

Thank Emmaniece, but one you master these skills you'll use them all the time.

Joe, thank you for sending the link to this tutorial. Frank and I just watched it. What camera did you use? We are going to start doing videos this year and trying to decide what camera to use. Please, let us know if you're ever over this way, we'd love to meet you!

Will do Sharon. I used camtasia (software, no camera required). It does a live screen capture that you can "do and record" at the same time.

FEB

Excellent tutorial I need to figure out how I can retrieve the info from my MLS though.

FEB

Raj, you might be able to buy it from a third-party as well. Good luck!

Leave a response…

Name:

Email:
(optional)

Comment:

What does the graphic say?