Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
condition chart color bar range
Hi all
I used macro of the colorbars() for my condition chart as below My question is I have another condition on column F, how can I add to this sub colorbars()? Thanks in advance. Daniel ---------------------------------------- Sub ColorBars() Application.ScreenUpdating = False Dim Rng As Range Dim Cnt As Integer Cnt = 1 For Each Rng In Range("E2:E41") Set Pts = ActiveChart.SeriesCollection(1).Points(Cnt) If Rng.Value = "" Then Pts.Interior.ColorIndex = 44 ElseIf Rng.Value = 2684 Then Pts.Interior.ColorIndex = 43 ElseIf Rng.Value = 1 Then Pts.Interior.ColorIndex = 5 End If Cnt = Cnt + 1 Next Rng End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cell by color and condition | Excel Discussion (Misc queries) | |||
Change row color based on condition of celss | Excel Worksheet Functions | |||
CONT.IF and color condition? | Excel Discussion (Misc queries) | |||
Color Change in chart based of condition | Charts and Charting in Excel | |||
IF CONDITION & Arrow instead of color | Excel Discussion (Misc queries) |