Conditional Format Chart

jckenney

New Member
Joined
Nov 16, 2013
Messages
7
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.

Is this task even possible?


Cheers James
 
Last edited:

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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
 
Upvote 0
Actual HoursCritical Hours
Cell 1Cavity #1PM #12500025000
PM #21900025000
PM #41800025000
PM #52600025000
PM #62200025000

<tbody>
</tbody>

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 
Upvote 0
The easiest method is to create two new columns containing simple formulas.
Excel 2012
CDEFG
1Actual HoursCritical HoursNot CriticalOver Critical
2PM #12500025000025000
3PM #21900025000190000
4PM #41800025000180000
5PM #52600025000026000
6PM #62200025000220000

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1

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

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>


Select columns C, F, and G and insert a stacked bar chart.
WZFbOtn.png
 
Last edited:
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Something like this?

gxu6U0M.png



Excel 2012
CDEFG
1Actual HoursCritical HoursNot CriticalCritical
2PM #12500025000249991
3PM #21900025000190000
4PM #41800025000180000
5PM #52600025000249991001
Sheet1
Cell Formulas
RangeFormula
F2=MIN(D2, E2-1)
G2=MAX(D2-F2, 0)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top