The colour change works for me but it does depend on the format I choose. When you copy the graph and choose to Paste Special as a link, you will see a choice on which format should be used.

If I choose Microsoft Excel Chart Object - colour changes work
If I choose Microsoft Office Graphic Object - colour changes don't work.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi,

If I try to paste the graph as Microsoft Excel Chart-object, I get an error message that there is een problem. If I first select paste link in the paste special menu, I get another type of error message that the data from the (...) link can not be obtained. Any idea what the cause of this is?