Conditional formating in Excel Charts.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you for the response. My workaround is a bit cumbersome now. I am
using separate data series for positive transactions and negative
transactions (selected via conditional statements) coupled with ranking and
lookup routines. It gets to a point when I think crayons and a straightedge
provide the most direct solution.

It appears that you have a great deal of valuable information at your site.
Water-fall charts while a great tool to relay information, can be a pain.

Thank you again.
 
Back
Top