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?
"David Portwood" <(E-Mail Removed)> wrote in message
news:47c8a7d6$0$6502$(E-Mail Removed)...
> 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
>
|
Similar Threads
