Vary colors in area chart by x-axis value
 

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.

--
Deirdre M.

Hi Deirdre,

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

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

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.

--
Deirdre M.