oints(x).Interior.Color = vbGreen
If .Points(x).DataLabel.Text > 70 Then _
.Points(x).Interior.Color = vbRed
Next
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Wednesday, January 11, 2012 6:08 AM
To: excel-macros@googlegroups.com
S
Dear All,
Is there any way to make a conditional chart. I need to make a conditional
chart. Kindly help me in this.
conditions
1. If value is Less than 40 = bar graph colour : Blue
2. If value is 41-70 = bar graph colour is Green
3. if value is 71-100 = Red
I'v attached the file for the sampl