Interactive Graphs

[Saxman]

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

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

Oops! I misunderstood your question

 

[Ed Ferrero]

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/

 

[Saxman]

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.

 

[Ed Ferrero]

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/