Correct, but you can very easily copy the data and use paste special
values or formulas to update the data on the copied worksheet with the
chart.

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


"SKlee" wrote in message
...
Thanks for your reply!
So, even if I already have the other sheets complete (which I do) there is
no version of "paste special" for a chart that will automatically populate
the chart with the sheet's data it is being pasted to? (Like being able to
copy a formula from one sheet to antoher?)

"Jon Peltier" wrote:

You'll find it easier if you copy the entire sheet, including charts and
data, then pasting the new data over the data in the copied sheet.

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


"SKlee" wrote in message
...
If I have a chart set up oin one sheet and need the same chart on a
differnet
sheet, but with the data on the new shee represented...do I have to
physically change the source on every sheet I copy it to or can it be
"programmed" to do it automatically? (I have 100 sheets and 4 sheets to
a
page so am hoping I don't have to edit source data on all 400 charts.)

Thanks in advance for any help!