I have a number of graphs imbedded in a worksheet, all using data from that
worksheet and only from the worksheet.

I would like to run a different analysis on the data and keep the original
analysis so I am trying to create a copy the worksheet and embedded charts in
the same workbood.

When I select "move or copy" selected sheets, with the "create a copy" box
checked, the worksheet is copied to a new tab, but the graphs are dropped.

There are a large number of graphs so I would like to not have to redefine
the ranges to point to the new data on each chart as would happen if I copied
the graphs from the old worksheet to the new, chartless worksheet.

This used to work as you world expect in 2003, but I can repeat this
behavior on any new or old workbook in 2007.

Is there a fix for this or a workaround for this bug?

DaveH