Is there way to automate a bar chart color based on value positive or negative. for example if the value is positive change the bar chart color to green, if the value is negative change the bar chart color to red.
Is there way to automate a bar chart color based on value positive or negative. for example if the value is positive change the bar chart color to green, if the value is negative change the bar chart color to red.
This looks a kind of complicated process. It is possible to create the same, but you have to define conditional formatting in the cell rather on the chart. You can setup a conditional formatting setup in table and define the appropriate values. I don't think it is possible to do that in the Chart itself.
No there is no option for that. You cannot simply add colors to the chart and make chart to change colors. That might need to use any 3rd party software which can provide you options for this purpose. Excel just offers you easy to chart and define the values based on the cell reference. There is no option to define automatic colors which will be changed based on the value inserted.
Bookmarks