4 Replies Latest reply on Nov 18, 2013 12:35 PM by Oscar Campos

    Is there a way to color columns in a column chart if they fall outside a reference band?

    Richard Holohan

      Hi, I'm trying to figure out if there is a way to color individual columns in a column chart based on whether or not they are within a banded range.  As an example, in the attached workbook, I'd like to color weeks 5 and 9 red because they have fallen outside of the reference band.  The reference band happens to be +- 1 standard deviation from the average.

       

      Thanks,

      Rich