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

In order to hide zero values in your Excel spreadsheet, click File on the Ribbon. Click Options, then Advanced. Scroll down about three-fourths of the way until you reach the section called Display ...

The Pointy Haired Dilbert blog runs down the details of this nifty Excel trickery, which uses a formula and an image to conditionally show or hide the chart —neat stuff sure to impress the boss.