Link a chart to a worksheet

[Roger Campbell]

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?

 

[Jon Peltier]

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