1. The hard way: Define a name for dates and one name for each series in the
chart (Open, High, Low, Close). Create the chart using static data, then
replace the static addresses with the names, either in the series formulas
or in the Source Data Series dialog.

2. The easy way: Put Date, Open, High, Low, Close into a table. Go to Data
menu List Create List. Make your chart based on this list. As the list
expands, any formulas (including chart series formulas) update to include
all rows in the list.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Nick Krill" wrote in message
...
How can I create "Name" that will enable a dynamic stock chart in Excel
2003.
I have been able to create single series dynamic charts using "Name", but
no
luck in creating a dynamic stock chart.