If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart Legend Color Index Assignment
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 |
#2
|
|||
|
|||
Chart Legend Color Index Assignment
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 |
#3
|
|||
|
|||
Chart Legend Color Index Assignment
That was it - thank you Jon.
"Jon Peltier" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|