Is it possible to have the columns in a stacked column chart be different colors based on their comparison to another value?
I have the following table of values representing rainfall amounts for each year with an average of all years:
Col A Col B Col C Col D Col E Col F Col G Col H Col I
Row 1 Year 2010 2011 2012 2013 2014 2015 2016 Average
Row 2 Rainfall 22.6 34.5 21.7 53.8 10.4 (empty) (empty) (empty)
Row 3 Average (empty) (empty) (empty) (empty) (empty) (empty) (empty) 28.6
I have a stacked column chart with 2 series: "Series 1" and "Series 2"
Series 1 gets its values from B2 thru I2 and is colored blue
Series 2 gets its values from B3 thru I3 and is colored red
Is it possible, WITHOUT VBA or a macro, to have the Series 1 columns be blue if their value is above the value in cell I3, and be green if their value is below the value in I3?
In my example, the columns for 2011 and 2013 would be blue, while the columns for 2010, 2012 and 2014 would be green.
I have attached a sample Rainfall stats Example.xlsx file.
Bookmarks