Thanks:  0
Likes:  0

1. ## Conditional Format Chart

Question to the experts.

I have created a bar chart and I'd like to have the color of the vertical bar change in color when the value 25K has been reached or exceeded.

Cheers James

2. ## Re: Conditional Format Chart

have a look at peltier charts, i can think if you know which bar it will always be you could drive it from VBA, but it maybe possible

3. ## Re: Conditional Format Chart

 Actual Hours Critical Hours Cell 1 Cavity #1 PM #1 25000 25000 PM #2 19000 25000 PM #4 18000 25000 PM #5 26000 25000 PM #6 22000 25000

4. ## Re: Conditional Format Chart

The easiest method is to create two new columns containing simple formulas.
Excel 2012
C D E F G
1 Actual Hours Critical Hours Not Critical Over Critical
2 PM #1 25000 25000 0 25000
3 PM #2 19000 25000 19000 0
4 PM #4 18000 25000 18000 0
5 PM #5 26000 25000 0 26000
6 PM #6 22000 25000 22000 0
Sheet1

Worksheet Formulas
Cell Formula
F2 =IF(D2 < E2, D2, 0)
G2 =IF(D2 >= E2, D2, 0)

Select columns C, F, and G and insert a stacked bar chart.

5. ## Re: Conditional Format Chart

y tutorial on this topic is at Conditional Formatting of Excel Charts.

6. ## Re: Conditional Format Chart

Jon, The above scheme works although it's not actually what I wanted the chart to look like.

I'd like a stacked chart to change at 25k and display red above that value. I'm at a loss

7. ## Re: Conditional Format Chart

So then the formula in the first column is MIN(Value, 25000) and in the second column is MAX(0, Value-25000). Stack these and you're golden.

8. ## Re: Conditional Format Chart

Something like this?

Excel 2012
CDEFG
1Actual HoursCritical HoursNot CriticalCritical
2PM #12500025000249991
3PM #21900025000190000
4PM #41800025000180000
5PM #52600025000249991001

Sheet1

Worksheet Formulas
CellFormula
F2=MIN(D2, E2-1)
G2=MAX(D2-F2, 0)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•