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

--
Message posted from http://www.ExcelForum.com

Hi Ola,

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

Cheers
Andy

Ola < wrote:

> Is there anyone who knows how to make conditional formating in a column
> chart. I want my positive observation to be blue and my negative red.
> Is this possible?
>
> /Ola
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

--
Message posted from http://www.ExcelForum.com