How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. ... The Invert if Negative option in Excel allows you to choose different colors for both positive and negative graphs.