Check out the color palette (Tools menu Options Color tab). The chart
uses the bottom two rows of colors for its data, then when it runs out it
cycles through the rest of the palette. If the palette has been customized
by someone unfamiliar with this behavior, you may get duplication of colors.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Bob Barnes" wrote in message
...
Looking for VBA code to run on Workbook_Open to ensure
a Legend having up to 10 different variables does NOT
"automatically" assign to same color to 2 different variables.

TIA - Bob