On 10 Nov 2005 02:04:00 -0800, topola wrote:

Sounds interesting topic. It doesn't seem difficult from the technical
point of view.

I thought that myself.

In the target sheet define a range e.g. "DATA" with the results data
and build a chart upon it (InsertChart or F11).
There should be one blank column in your data range so that you could
easily add new column in between.

Not quite sure what you mean by blank column. Where do I place it?

You need a simple macro to move the data from the source sheet to the
target sheet to be placed in the
new column in the "DATA" range whenever new data is captured. The
chart should be update automatically.

I do not want the data to be represented by a bar chart. A line graph
would be better so that fluctuations in price could easily be observed as
the data was gathered.

Thanks for the help.