Chart Legend Color Index Assignment

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

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
 
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
 
That was it - thank you Jon.

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top