Conditional formating in a Chart

[Ola]

Is there anyone who knows how to make conditional formating in a colum
chart. I want my positive observation to be blue and my negative red
Is this possible?

/Ol

 

[Andy Pope]

Hi Ola,

Take a look at Jon's examples.
http://peltiertech.com/Excel/Charts/format.html#CondChart

Cheers
Andy

 

[Nicky]

I don't think you can have conditional formatting in the chart itself.

However, this code sets the interior color of all series to "3" (re
in the default colo scheme) if its value is below 0, otherwise to "5".


Sub change_cols()

For Each ss In ActiveChart.SeriesCollection
values_array = ss.Values
For n = 1 To ss.Points.Count
If values_array(n) < 0 Then ss.Points(n).Interior.ColorIndex =
Else ss.Points(n).Interior.ColorIndex = 5
Next
Next
End Su