It's actually a one time deal. I have 100 employee benefit statements already
laid out in Excel and want the same 4 charts to appear on all of them. I did
one set of charts on one record and was hoping to copy/paste to the
rest...like a formula. Looks like I am out of luck! Thanks for the reply!

"Del Cotter" wrote:

On Fri, 25 May 2007, in microsoft.public.excel.charting,
SKlee said:
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.)

I'm not actually sure why so many people come here with tales of
hundreds of identical Excel charts they are required to keep updated.
Doesn't that count as workplace harassment?

This may help:

http://www1.juiceanalytics.com/
writing/2007/05/why-make-100-charts-when-one-will-do/

I don't mean you should duplicate that example exactly, but in general,
using OFFSET could be the key to never having to copy a zillion separate
charts again.

In the meantime, why not change the four charts on one sheet, then copy
chart and sheet together 100 times. Seven rounds of "select all sheets
and copy them" ends with 128 sheets; then you can delete the last 28 to
leave 100. Copying the chart together with its old sheet means the chart
will read the new, copied sheet, not the old one.

Finally, copy the data from the old 100 sheets to the new 100 sheets.
The new charts will then have the old data to read, which is the same as
copying a chart over and then changing the source data, but with less
hassle.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.