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