Need help shading negative value plot area in a Scatter Graph

[Josh H]

Hello,

I have two values in my graph that are negative and I'm trying to shade the area less than 0% red. How do I do this using VBA?

Thanks,

 

[Hui]

Add a second series to the chart
In the second series only have the negative values,
In the first series only have the positive values,
Format the second series as a red marker etc

See attached

 

[Josh H]

Thanks for the help Hui. I looked at the attachment and didn't see any changes made? I'm adding the changes I made to mine based on your reply. How do I format the new series so the plot are is red? I'm not following you.

Thanks!

 

[Hui]

I don't know what happened there ?

See attached:

 

[Josh H]

Thank again Hui!