title: How do I keep colors consistent from chart to chart in Reporting Services 2005?
body: <p>I created a custom color palette for my charts using <a href="http://technet.microsoft.com/en-us/library/aa964128(SQL.90,printer).aspx" rel="nofollow noreferrer">a technique described</a> on TechNet.</p>
  
  <p>I also have a series of drill-through column charts, where you click on one column and it passes a parameter through to the next chart and so on, giving the appearance of drill-down.</p>
  
  <p>My graphs consist of 3 types of labor, and have three colors on the main chart.  When I drill down to the next chart, some of the categories do not have all three types of labor that the main one has.  So the first color in the palette is assigned to the series, even though it was the second color on the previous chart.  I'd like to avoid this, if possible.</p>
  
  <p>So a data value is green on the first chart (2nd in the color order) and yellow on the next chart (1st in the color order).  How do I make the graphs "remember" the total number of series groups that were in the first chart?</p>
  
  <p>This is Reporting Services 2005.</p>