I have a problem with charts linked to another excel file.

[Sue]

I have a chart file that is linked to another file with the data. I cannot
get the chart file to keep the format that I want. I keeps changing to show
decimals and no commas.

 

[Jon Peltier]

Double click the text element that keeps changing its format. On the Number
tab of the Format dialog, uncheck the Linked to Source checkbox and select
an appropriate format. It should remain unchanged from now on.

- Jon