I have a chart within excel.

The chart takes data from Cell B1. This contains a number say 100 for
example. It then plots this on a graph. The hundred may change the
following day to say 110 and so on and so forth.

What I want to be able to do is have the graph plot each point on a
graph showing the movements daily.

The problem is the cell is B1 refreshes each day with the new figure.
The data is not stored anywhere.

Is there a macro or something that is possible to achieve this?

Thanks in advance

Andrea