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/
