linked Excel charts don't match formatting in original

[Stefan Gildemeister]

I have one spreadsheet in which I created charts linked to worksheets in the
same file. These charts I have exported (i.e. copied into another file).
When I open that other file without having the original file with the data
open, the labels on the charts don't reflect the number formatting that was
selected for them: .09 instead of 9%.

Any help would be appreciated as I can't figure out how to fix this. For
instance, is there a way to break the link to freeze a certain look of the
charts?

Thanks,
Stefan.

 

[fernmp]

You could copy and paste the poicture rather than the link. If you'r
pasting into another iscorsoft programme, use Paste Special!Picture

 

[Jon Peltier]

The formats link to the source, if the source file is open. If Excel can't see the
source data formatting, it uses the General format.

To lock in the format, reopen the source file, double click on the labels or axis
with the numbers, click on the Number tab, and uncheck the Linked to Source box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______