"Fredrik E. Nilsen" wrote in message
...
A couple of more questions then comes to mind: If I apply your code
this affects all charts in the workbook. This is not necessarily a
problem but is there a way to affect only the selected chart?

Shane's code affects the color palette in effect for the entire workbook.
Therefore it affects every chart and every worksheet in the workbook.

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