Excel 2007 : Data input field and auto chart update

[roger4607]

I have a spreadsheet regarding electricity consumption. Each day I have to manually add a row and input the date and the meter reading in the first 2 fields in a row then the remaining 8 cells in the row do my calculations for me. I then manually - each day - create a chart from the calculated data.

Basically I would like to be able to do 2 things. Firstly, I would like a data input page where i simply put in the date and meter reading, this info would then create a fresh line on my data page.

I would also like my chart to update automatically whenever a row is added - are these 2 things possible??

[mrice]

Both possible - can you post the actual workbook for further help.