Does anybody know where I can obtain Excel templates with an interactive
graph, i.e. something like a stockmarket spreadsheet which continually
updates the data?

TIA

http://peltiertech.com/Excel/Charts/index.html#hdrDyno


--

Regards,

Peo Sjoblom


"Saxman" wrote in message
...
Does anybody know where I can obtain Excel templates with an interactive
graph, i.e. something like a stockmarket spreadsheet which continually
updates the data?

TIA

Oops! I misunderstood your question


--

Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
http://peltiertech.com/Excel/Charts/index.html#hdrDyno


--

Regards,

Peo Sjoblom


"Saxman" wrote in message
...
Does anybody know where I can obtain Excel templates with an interactive
graph, i.e. something like a stockmarket spreadsheet which continually
updates the data?

TIA

HI john,

Does anybody know where I can obtain Excel templates with an interactive
graph, i.e. something like a stockmarket spreadsheet which continually
updates the data?

TIA

To create a data list that continually updated the data from an external
source, use Data - Import External Data - New Web query... Then edit the
data range properties to refresh every x minutes.

The imported data will have a named range (you can edit this in data range
properties) so the data in the named range will be dynamic.

Just create a a chart using the name. Or use dynamic range techniques
explained in several places (eg http://edferrero.m6.net/vba.shtml) to chart
what you want.

Ed Ferrero
http://edferrero.m6.net/

On Tue, 22 Nov 2005 11:32:33 +1100, Ed Ferrero wrote:

Just create a a chart using the name. Or use dynamic range techniques
explained in several places (eg http://edferrero.m6.net/vba.shtml) to chart
what you want.

Error 404, object not found, but the main URL works. Thanks.

Error 404, object not found, but the main URL works. Thanks.

Sorry, I've been working on the web site. Should be right, now.
Expect to see it moved to www.edferrero.com soon.

Ed Ferrero
http://edferrero.m6.net/