Chart's Data Table, losing formatting after paste

[David Portwood]

Using Excel 2003 I'm trying to copy a chart with data table from one
spreadsheet and paste it into another spreadsheet. In the source
spreadsheet, the values in the data table are nicely formatted as currency,
but when I paste the chart + data table into the second spreadsheet, save
the changes, close the spreadsheet, and later reopen it, the formatting is
gone and the values in the data table now appear in, I suppose, general
format.

I'm dealing with a chart object, not cells. There seems no way to explicitly
reformat the object so the data table values appear as currency. At least,
no way that I could find. Does anyone recognize this problem? Is there a
solution?

Thanks in advance,
David Portwood

 

[David Portwood]

Rereading my original post, I think I may not have explained this clearly.
Let me try again.

A workbook has a chart object (which includes the data table for the chart).
I want to copy this chart object and paste it into another workbook.
However, when I do this I lose the formatting of the values in the chart's
data table.

Well, rereading this clarification doesn't make me feel much more confident
about my explanation of this issue. I hope y'all can read between the lines
if I'm not making sense.

Does this problem sound familiar to anyone? Is there a way I can copy and
paste the chart object (with its embedded data table) and preserve the
original formatting of the data values?