Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

conditional formatting for line and column chart

Hi everyone! I have found some ideas in conditional formatting for bar chart in the forum. But is there a way to format the color for line and column chart? Like I hope that the column with negative value to have red color.

 

 

The line and column chart has no legend field nor color saturation field. Can I do the conditional formatting in line and column charts? 

 

Thank you very much!

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

    Anonymous

     

    To assign conditional color in chart, you need to put same Value field into Color saturation. Then you can enable Diverage and specify value range for different color. 

     

     

     

    Currently, it's not possible to show the label for last column only. You have to show/disable all labels. 

     

    Regards,

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    And can I ask whether there is a way to only show the data label of the last column?

     

    Thanks

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

    Anonymous

     

    To assign conditional color in chart, you need to put same Value field into Color saturation. Then you can enable Diverage and specify value range for different color. 

     

     

     

    Currently, it's not possible to show the label for last column only. You have to show/disable all labels. 

     

    Regards,