- 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.
- 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.