The California Association of Realtors® (CAR) publishes monthly home price data for each county in California. I produced a dashboard using their data and the 2010 census for income and population data.
In order to keep the dashboard up to date, the “All Counties” sheet stores the data from CAR. There is a link to the data on the sheet. I like to copy all the names and price data into cell A8 because CAR makes adjustments periodically to historic data. After that, you will see a red button that says “Change NA to #NA”. The chart cannot properly show data if there is a text NA, so this macro replaces any NA with NA().
The dashboard starts with the user selecting three counties with list boxes. Then the starting date and ending dates, also in list boxes. In this part of the dashboard you get the starting and ending median home prices, the delta and the annual percentage change (APR).
Below this data you get a chart showing the three counties’ prices for the dates chosen.
To the right are three maps of California with the three counties shown in red, along with statistical information from the 2010 census. This information can help explain the average home prices for each county.
Left of center depicts the highest price county and the lowest. In this case, a date is required in the yellow cell, which is a drop down box.
Download spreadsheet “Home_Prices“.
Created in Excel 2013