Special offer

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

Reblogger
Real Estate Agent with eXp Realty

I like using visuals in my market reports, so when I noticed that Denise Hamlin had made some cool two-axis charts for her reports I had to ask her how she did it. 

Using Screenr.com, a great free tool that you can use to record tutorials, Denise made this handy tutorial.

Here's the chart I made-

total home sales and median sales price

If you want to see how to do this watch the tutorial below-

Original content by Denise Hamlin, Broker/Owner

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 

 

 

Let's Connect and Get To Know Each Other...

Denise Hamlin Facebook Graphic          Denise Hamlin twitter graphic         Google+ Profile         Pinterest Profile Denise Hamlin

Search for Iowa City Homes for Sale

Selling A Home in Iowa City, Coralville & North Liberty IA

Subscribe to receive regular market reports, info on schools and community updates by email


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 (3)

Denise Hamlin, Broker/Owner
Cardinal Realty ~ 319-400-0268 - Iowa City, IA
Helping Happy Clients Make Smart Choices

That's awesome Rich. Love your background. Thanks for the reblog.

Nov 14, 2013 11:54 PM
Rich Cederberg
eXp Realty - Albuquerque, NM
eXp Realty Agent Albuquerque

Steven, Market reports are a great way to get your blog in front of consumers.

You're welcome Denise. I'll be doing more on excel going forward. Thanks for the tutorial.

Nov 16, 2013 09:43 AM