separate colors for positive and negative bars in bar charts?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the "invert if negative" function in an excel chart, is it
possible to set a default color for negative numbers (i.e. positive bars will
be Blue and negativ Red)? I know you can change the colors individually, but
have not found a way to make it dynamic. This gets tedious when updating
weekly charts.
 
Back
Top