title: How can I make the legend in an SSRS chart correspond with custom chart fill colors?
body: <p>I have a simple chart in SSRS that uses the following expression to define the color of each bar in a chart:</p>
  
  <pre><code>=Switch(
  fields!Dept.Value="1","Blue",
  fields!Dept.Value="2","Red",
  fields!Dept.Value="3","Yellow",
  fields!Dept.Value="4","Green",
  fields!Dept.Value="5","Purple"
  )
  </code></pre>
  
  <p>While this works fine for changing the color of each bar, this change isn't reflected in the legend - it still displays the single value of the Y axis with the default blue color. Is it possible to have the legend reflect the colors in the expression? I have tried putting the same expression in the custom legend text option, but this does not work.</p>