How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same ...

Excel's intercept function takes the data points that define a line on a graph and calculates the y value for the point on the graph where x is equal to zero.