My chart Labled CASHFLOW is taking its date from the table above Column DIFF (Column F). Is there wway that when the chart is negative the color of the actual bar (currently orange color) is another color say Red for example??? I would just like the columns in the negetaive section to jump out. Thank You
There was a simlar question in the recent past where Jerry or Barry suggested the you could make two columns for a single data set. Let's say column A has the original data. Column B could have the positive and non-zero values while coluimn C could have negative values. When you graph columns B and C they can be assigned the color you want.
The idea was something like:
C2=IF(A2>=0, A2, "")
D2=IF(A2<0, A2, "")
select C2 and D2, then fill down as needed
There was a simlar question in the recent past where Jerry or Barry suggested the you could make two columns for a single data set. Let's say column A has the original data. Column B could have the positive and non-zero values while coluimn C could have negative values. When you graph columns B and C they can be assigned the color you want.
The idea was something like:
C2=IF(A2>=0, A2, "")
D2=IF(A2<0, A2, "")
select C2 and D2, then fill down as needed
SW,
The Stacked Bar Chart is a good way to combine two series in a way that appears to be one series with a color difference.
The formula in C2 is:
=MAX(B2, 0) Fill Down
The formula in D2 is:
=MIN(B2, 0) Fill Down
Regards,
Jerry
Chart: Can the same data set have different color for neg. numbers?
