Color change on bars when goal met

  • Thread starter Thread starter wgnewman
  • Start date Start date
W

wgnewman

How do you have a bar change/begin a new color when the total reaches and
surpasses a goal/target? For example, if a series has totals above and below
a goal of, say, 70, I want each bar to show when that goal is met and to have
a different color on the same said bars displaying the amount above the goal.
 
Hi,

What you need to do is break your data range into two data ranges, one for
values above 70 the other for ones below, to do that us a formula approach.
Say you data is in B1:B10, which x axis data in column A. In C1 enter the
formula
=IF(B1<70,B1,70)
In cell D1 enter the formula
=IF(B1>=70,B1-70,0)
Copy these two formulas down and plot the range A1:A10 and C1:D10 as a
Stacked bar.


If this helps, please click the Yes button.
 
Back
Top