creating line chart based on one cell that auto updates over time

[steve78]

Hi,

your help with be most appreciated.

i was wondering if this was possible in excel.

i have a spreadsheet containing detail of weather. example is attached.

this spreadsheet would be linked to some software which collects the data of weather in degrees.

the spreadsheet updates the data and overwrites the cells every 1 hour.

i would like to create a line chart that records the data in cell c3,c5,c7 , etc - basically all the changes in degrees over time.

unfortunately each update, every hour, rewrites the existing data.

is there any way i can plot the line chart - to say show for example london 09.00 = .08 degrees, 10.00 = .12 through to 14.00 = .22

many thanks to anyone that can help with this

steve r