How do I change the color of a series when it’s below / above 0 (or any other value)?

  1. Create two series, one containing only the values above 0 and another containing the values below 0, and then graph each series in a different color. Do the following:

    a) In the series list, type the expressions:

    if(series >0, series, Null())
    
    if(series <0, series, Null())

    b) In the chart, click on a graph and open the Presentation properties tab. Select “Custom” from the graph style drop-down menu in the appearance group. Select the color of your choice.

  2. Flag the values below 0 as forecast values, and change the color in which forecast values are graphed, by doing the following:

    a) In the series list, type the expression:

    if(series > 0, series, flagforecast(series))

b) In the chart, click on the graph of the series and open the presentation properties tab. Select “custom” from the graph style drop-down menu in the appearance group. Click “forecast.” Select the color of your choice.