| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Color/Color Index | Excel Discussion (Misc queries) | |||
| legend on the chart | Charts and Charting in Excel | |||
| Bar Chart Legend Key | Charts and Charting in Excel | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| pie chart legend | Charts and Charting in Excel | |||
Linear Mode
