How To Create A Chart with 2 Axis in Excel for Market Reports (Video)

By
Real Estate Broker/Owner with Cardinal Realty ~ 319-400-0268

Market reports are popular with buyers and sellers alike. Everyone wants to know what the market is doing! I've been writing mine since 2010, (soon after I signed up with AR). I soon found out that rows of data makes for a pretty dry user experience and it didn't take long for me to start adding charts. They've been a hit since the beginning and my market reports always come up as a topic of conversation when I meet with clients who find me through my blog. 

I often get questions from agents too who wonder how I manage to make my charts look so different with a photo in the background and that kind of thing. For the longest while I've wanted to check out one of those screen casting sites to create a video of my desktop. Today was the day - And as it turns out it couldn't have been easier than it was with Screenr

Of course, apparently time is moving along without me. I call this a video tutorial of how to create a chart with a primary axis and secondary axis. These days it seems it's called a screen cast. Oh well. I wasn't about to start over just to change that...

Here's an example of one of my charts on a blog post: Market Trends in North Liberty 

 

 

Posted by

Denise Hamlin, Realtor®

Broker/Owner

CARDINAL Realty, Coralville IA 

Licensed to Sell Real Estate in the State of Iowa

 

Helping Happy Clients Make Smart Choices 

Iowa City Area Real Estate Services

 

Please remember that opinions expressed in my blog are just that - opinions - not fact
For legal or accounting advice please consult with a professional
Although the information provided is deemed reliable, it's not guaranteed

 

Comments (12)

Sandy Padula and Norm Padula, JD, GRI
HomeSmart Realty West & Lend Smart Mortgage, Llc. - Carlsbad, CA
Presence, Persistence & Perseverance

Denise, very helpful Excel tutorial. Looks like you have this process simplified and you made it quite understandable. Thank you!

Nov 14, 2013 06:34 AM
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

Hi Norman, Thanks for the feedback. I'm glad you found it easy to understand. I was kind of hoping I hadn't rushed through it too fast and skipped something important. (Easy to do if you use it all the time).

Nov 14, 2013 06:44 AM
Rich Cederberg
eXp Realty - Albuquerque, NM
eXp Realty Agent Albuquerque

Thanks Denise, I've redone my chart. I'm going to reblog your post and put it in the intro.

Nov 14, 2013 12:25 PM
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

Love the new chart Rich, especially what you've done with the background. The background is a great way to personalize a chart. 

 

Nov 15, 2013 12:06 AM
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

Thanks Corinne. I've wanted to try something like Screenr for a while. Rich gave me the idea and this seemed like the perfect opportunity. I couldn't believe just how easy it was to use!

Nov 15, 2013 12:07 AM
Joe Petrowsky
Mortgage Consultant, Right Trac Financial Group, Inc. NMLS # 2709 - Manchester, CT
Your Mortgage Consultant for Life

Nice job with your coaching. It seems like you know the process very well.

Make it a great evening!

Nov 19, 2013 09:17 AM
Jon Zolsky, Daytona Beach, FL
Daytona Condo Realty, 386-405-4408 - Daytona Beach, FL
Buy Daytona condos for heavenly good prices

Wow, this one was very interesting. I never thought of sprucing up my market reports, but after this presentation, I will play with it, thank you

Jan 07, 2014 12:29 PM
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

It's surprising how easy it is once you get the hang of it Jon. It's worthwhile taking the time as charts and graphs really are a great way for consumers to visualize what is otherwise very dry data. 

Jan 08, 2014 01:32 AM
Cheryl Ritchie
RE/MAX Leading Edge www.GoldenResults.com - Huntingtown, MD
Southern Maryland 301-980-7566

This is really neat. I needed a refresher on this. I get spoiled because of the RBIntel stats product in our area.

Jan 08, 2014 11:22 AM
Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

Glad you found it useful Cheryl. When I haven't done it in a while I need to think about it too. And thereby it is really SO easy once you get the hang of it and do it regularly!

Jan 09, 2014 12:50 AM
Bob Crane
Woodland Management Service / Woodland Real Estate, EXP - Stevens Point, WI
Forestland Experts! 715-204-9671

Great tutorialm Denise, my charts seldom look this nice, it was a good lesson for me to improve.

Jan 10, 2014 01:58 PM