who do i conditionally change bar chart colors?

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

Guest

I want to change colors of the bars in a chart based on conditions. So if
there is a negative number, i want one color. If the number is +ve, i want
another color. This is similar to conditionally formatting of cells, except
for bars.
 
You need several series to do this. Have one series for negative numbers,
and another for positive numbers. Just make sure you include ZERO in your
calculations.
 
Back
Top