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

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/...bars_version_1

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

--
John Mansfield
http://cellmatrix.net





"tris" wrote:

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

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...2/Default.aspx

Ed Ferrero

This approach uses no macros:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"tris" wrote in message
...
is there any way i can color code bars with reference to the y axis,
without
manualy changing the colors