Link a chart to a worksheet
 

If data on one worksheet (swimming times) is used to create a graph or chart
on another worksheet, can I automatically update the graph when I add new
data to the original worksheet?

Link a chart to a worksheet
 

Do you mean when you expand the data? Dynamic charts don't care where the
data is, as long as the ranges are properly defined:

http://peltiertech.com/Excel/Charts/Dynamics.html

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


"Roger Campbell" wrote in message
...
If data on one worksheet (swimming times) is used to create a graph or
chart
on another worksheet, can I automatically update the graph when I add new
data to the original worksheet?