Chart Showing Daily Change

[jdpro]

Hi Mr. Excel fans,

I would like to make a chart that graphically plots each day's values. I use =TODAY() in one cell, and manually enter new values for each day, with simple calculations for the data. I would like to just keep this little box to enter the data just for the current day, and then have a chart below it on that sheet that can track the history, so I don't have a spreadsheet that keeps growing bigger, just the chart itself. Hope that makes sense.

Thanks to everyone for so generously sharing your knowledge and expertise.

 

[Legacy 143009]

That was the thing which I was not able to understand 20 years ago when I started to learn excel.
I had a vba macro tracking the exchange rates online and I was asking to myself "well, I am getting daily values, howcome a graph can't remember the old plotted data there?"
I asked to many friends and posted to many forums. Maybe my first post in this forum is about that story.
Long story short, a data point on a graph is not something like you throw a dart on a dart board which can stay there forever. It needs to read coordinates from somewhere. You have to have that data logged at somewhere else for graph to read from.

 

[jdpro]

Flashbond, I was sort of thinking that might be the case, but thought it was worth a shot.