top of page

Create and Learn Books - a quick and easy way to learn by doing

  • Writer's pictureCreate 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!