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