If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Color change on bars when goal met
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. |
#3
|
|||
|
|||
Color change on bars when goal met
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. |
Thread Tools | |
Display Modes | |
|
|