have you tried creating a button and using the macro recorder to create the
graph, then clicking on the button to view the graph when needed.
It can use the updated B1 value each time run.
Corey....
wrote in message
oups.com...
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