Color change on bars when goal met

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

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Overlay line graph points on bar graph 1
Gantt task bars not printing 2
Creating a goal or target line 1
Need help modifying code 0
How do I set a goal line in a bar graph? 3
Goal Seek with variable Set Cell 1
Insert two points horizontal 1

Top