Additional note: if you make the data a List in XL2003 or a Table in XL2007,
then make the chart, the chart is automatically updated when data is added
to the List/Table
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"glenlee" wrote in message
...
There are excellent instructions for creating a dynamic chart at:
http://www.peltiertech.com/Excel/Cha...umnChart1.html

That source data is presented vertically.

How do I modify the formulas to get a dynamic chart when my source
data is horizontal across columns A-Z for example?