Macro to design a dynamic graph

[amorrison2006]

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

 

[Corey]

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....

 

[Stopher]

How is the cell B1 being populated?

You could have a macro that if file/data being imported into B1 <0 then
insert a cell at B1 and move all the data down. If the cell in B1 is
part of a report have a data sheet, that way the report could pull from
this data sheet as well.

If you are querying a datbase for the result/data in B1 maybe you need
a smarter query that pulls a series of data into the above proposed
data sheet.

Stopher