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.

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

If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data. Microsoft Excel 2010 does not plot hidden ...