Chart Legend Color Index Assignment

[Bob Barnes]

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

 

[Jon Peltier]

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

 

[Bob Barnes]

That was it - thank you Jon.

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/
_______