separate colors for positive and negative bars in bar charts?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing color of negative bar when using Invert if negative 9
Inverse colors in bar chart 1
Conditional formating in Excel Charts. 4
Stack bar charts with positive and negative numbers 2
Excel 2007 Negative Bar Colors in a Chart 2
Conditional formatting in a bar chart 4
bar color "invert if negative" only white 1
Negative Values in Stacked Bar Charts 3

Top