G Guest May 15, 2007 #1 is there any way i can color code bars with reference to the y axis, without manualy changing the colors
is there any way i can color code bars with reference to the y axis, without manualy changing the colors
G Guest May 15, 2007 #2 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
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
E Ed Ferrero May 15, 2007 #3 Hi tris, is there any way i can color code bars with reference to the y axis, without manualy changing the colors Click to expand... Download the 'Conditional Format Bar Chart' sample from http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx Ed Ferrero
Hi tris, is there any way i can color code bars with reference to the y axis, without manualy changing the colors Click to expand... Download the 'Conditional Format Bar Chart' sample from http://www.edferrero.com/ExcelCharts/tabid/102/Default.aspx Ed Ferrero
J Jon Peltier May 15, 2007 #4 This approach uses no macros: http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon
