I have 150 color charts that will utilize the same series of legends. However not all graphs will use all 26 legends. Some might use 4 while others might use 12 legends. I want to standardize the colors used by all the graphs. First, do I need to put all 150 charts or graphs on one worksheet? And second, how do I make all graphs use the same set of colors. I have a vague idea that a subroutine needs to be called for each chart in order for that chart to display the "selected" color from the standardized color set.

Help!