Color coded bar chart

[tris]

is there any way i can color code bars with reference to the y axis, without
manualy changing the colors

 

[John Mansfield]

If you're open to using macros, these two examples show how to color bars
based on X-Axis data. The examples can easily be adapted to Y-Axis criteria:

http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_1

http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_2

 

[Ed Ferrero]

Hi tris,

is there any way i can color code bars with reference to the y axis,
without
manualy changing the colors

Download the 'Conditional Format Bar Chart' sample from
http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx

Ed Ferrero

 

[Jon Peltier]

This approach uses no macros:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon