Vary colors in area chart by x-axis value

[Deirdre M.]

I have an area chart that displays electricity usage (y-axis) for each hour
of one day (x-axis). I want hours 1-7 to be blue, 8-12 green, etc.

 

[Ed Ferrero]

Hi Deirdre,

There is a 'Conditional Chart Formatting' sample workbook at
http://edferrero.m6.net/charting.aspx

Ed Ferrero
http://edferrero.m6.net/