
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!
Subscribe to get tips and free material
Comments