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 ...

This difference is called its residual. A residual plot charts these values against the first variable to visually display the effectiveness of the equation.

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you're tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.