Copy and paste cahrt to new sheet-update data automatically?

[SKlee]

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!

 

[Jon Peltier]

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

 

[Del Cotter]

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.

 

[SKlee]

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?)

 

[SKlee]

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!

 

[Jon Peltier]

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