You can incorporate this within an if statement and even make automatic by
putting in the worksheet_change event of the sheet code.

Sub seriescolor()
ActiveSheet.ChartObjects("chart 1") _
..Chart.SeriesCollection(1).Interior.ColorIndex = 3
End Sub

--
Don Guillett
SalesAid Software

"REvans" wrote in message
...
Can bar chart colors be tied to and change with a given criteria (a
conditional format for graphs)?

I am trying to color code variations in a waterfall chart (using Excel's
Bar
Chart). I would like to code bars associated with positive impacts in
green
and bars associated with negative inpacts (not negative numbers) in red.

Thanks