Create and Learn
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!