Create a Form to Input Data

Hi,

I am looking to create a Spreadsheet for the input of data over a long time, which will then output graphs and a certificate (showing some data) each time new data is added.

For example, say data is added every quarter. I would like it so when you come to add that data you simply input a date, your name, and the data needed. This data will then be added to a series in a line graph, showing how the values have changed over time. I would also like these values to be expressed on a sheet to act as a certificate. This would have to change every time data is input as the certificate only needs to show the latest values and to then be printed off, whereas the graph would be having values added onto the end of a series, to show the change over time.

Hopefully I have explained that well. Is this doable? How might I achieve something similar, if it isn't

Thanks!

Start off with an input sheet.
eg. A1 type "Date" so that B2 will be where the date is actually typed
Then A2 type "Name" so that B2 will be the cell where a name can be entered, and so on...

then of course you will need to Name the cells where the data is going to be entered.
Once that is done, you set up your page where each entry is logged ( a simple code can be used to ensure typed data is always placed in the next empty rowss available) This would become your "LOG".
On a 3rd sheet, set up a chart, that will change upon filtering dates, names, data etc from the log to show the graph you want, be it current, historic data, or both.
Then you can modify and Sort/Filter any views you like.

I have created a sample sheet for input, use/edit/delete any parts you do not need.
I really just have had too much time on my hands the last couple of days (not complaining)
Hope this helps you get started...