T
tris
is there any way i can color code bars with reference to the y axis, without
manualy changing the colors
manualy changing the colors
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
E
Ed Ferrero
Hi tris,
Download the 'Conditional Format Bar Chart' sample from
http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx
Ed Ferrero
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
J