Problem copying sheet with chart using defined names

[Kevin]

I have a sheet that uses local defined names, such as
Chart1!MyXData. In this sheet I have a chart which refers
to Chart1!MyXData for the x axis values. When I copy this
sheet, new local defined names are created, such as Chart1
(1)!MyXData, however, the new chart created has the raw
data values for the x data instead of the new local
defined names. How can I set up the chart so the x values
will be the new local defined name?

Any help would be greatly appreciated.