Excel Tips - Negative Values

You can make negative columns automatically turn red in an Excel chart

Right-click the column and select Format Data Series.

Select Solid Fill, and check the box Invert if negative. Then, select the colors.

The column chart will tell a great story!