You don't need a macro:

http://peltiertech.com/WordPress/200...ynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Neweirs" wrote in message
...
I have scatter charts that will change as new data is added but I can't
seem
to get my macro that adds the data labels to work with defined names. Does
anyone know if this is possible?

Thanks in advance for any help that anyone can give me!