A residual plot charts these ... Value Is Less Than Zero in Excel? How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. When you... How to Do Derivatives in Excel.