I have been busy working on a series of detailed marketing report for real estate transactions that have closed escrow in San Jacinto, CA. My reports have typically been words...I look at the data and see what I think is important and not being reported elsewhere. I have tried to make the reports as interesting as possible - but they have been just words...and lets face it, no one can make raw data very interesting, for very long.
So, I have been playing around in Microsoft Excel and the chart function. While my typical report gets into great detail about each segment of the market, I have not been able to build a chart that easily explains the information I am trying to convey, in a clear, concise manner.
Hoverer, looking at specific elements of the San Jactino real estate market I have easily prepared a series of charts that relay the trend in a very specific of the report.
My first chart simply looks at the number of real estate transactions that have closed escrow over the last 120 days - broken down into 30 day periods.
The second chart that I am willing to make public shows the number of transactions per price range, in $25,000 increments.
I hope this works out. It was educational and fun figuring out how to build chart - basic I'm sure, but a function I never played around with before today. I have a feeling, you are going to be seeing more of these in the future.
Comments (7)Subscribe to CommentsComment