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.
--
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.