Color change on bars when goal met

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(B170,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 C110 as a
Stacked bar.


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"wgnewman" wrote:

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.

For an example of what Shane talks about see
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
www.stfx.ca/people/bliengme


"wgnewman" wrote:

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.