Next, I need to create two data series to label the horizontal axis. One data series for the positive labels and one for the negative. These series will represent a horizontal line at y = 0, the level of the horizontal axis.
5. Type the following formula in cell D3:
= IF(C3 >= 0,0,NA())
6. Type the following formula in cell E3:
= IF(C3 < 0,0,NA())
7. Select the range D3:E3, and then drag the handle to copy and paste the formulas into the range D4:E11.
The worksheet should look like this: