Thinking outside the box:
if your data is basically the same layout, same number of series and
categories etc, then select your chart, go to "save as template" and
give it a sensible name.
Now on each sheet you need to select your data, insert a chart and
choose your template as the chart type.

You could even macro record the insert job, andy postioning and resizing
etc, then repeat this on every sheet.

Hope this helps (even though it does not actually copy your chart at all!)

Adam

On 04/03/2010 21:15, Sam wrote:
Hi,

I have workbook with about 50 sheets. they have exactly the same table ,
just data(numbers in the table) are different. Also created a chart
based on the table in the first worksheet. Chart is embedded in the
sheet). I spend some time to format the chart and want to copy and paste
it on the other sheets, but I want to reflect the data in each sheet. So
each sheet has its own graph, which looks similar but reflects data on
the sheet.
Problem I am having is when I copy/paste it it paste absolute reference
, so I have manually to fix data range :( and with that many sheets its
kinda cumbersome.. and this is not the only file :(
Any suggestions how I can copy my chart so it reflect the data on the
sheet that is copied to?

Thanks,
Sam