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!