Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Clustered columns using color saturation

I have a clustered column chart for each month of the fiscal year showing remaining hours. I would like columns to fade for months with a < 120 hours value. I followed the instructions in the guided learning section but when I drag a field to Color saturation in the Visualizations area, it does not accept it. What am I doing wrong?

 

 

Columns less than 120 should fade.

Cannot move fields to Color saturation

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    The clustered column chart has multiple colors for your several values. You may go to ‘Format’->’Data colors’ to change them. The color saturation can be used when there is one value in chart such as below picture.

     

    Regards,

    Cherie

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous

     

    The clustered column chart has multiple colors for your several values. You may go to ‘Format’->’Data colors’ to change them. The color saturation can be used when there is one value in chart such as below picture.

     

    Regards,

    Cherie