I have data for all the historical sale prices of all houses on my street... so for each house I have a list of at least one date/£price point.
I want to enter this into an Excel spreadsheet so that on the same chart, I can get a separate line-graph for each property. For example #12 might have sold 3 times in 2000, 2003, 2010 whereas #30 might have sold only once in 2000.
I'm not sure the right way to tabulate this data and graph it as desired. Could I for example have column A as house-number, then column B, D, F, etc having sale date and C, E, G, etc having sale price? Or perhaps a simple 3-column setup where each row lists house-number, sale date, and sale price - can Excel let me explain all rows with the same house-number should be grouped into a separate line-graph?