First value on X axis (point 1) doesn't intersect Y axis

[Excel_VBA]

My first data point is supposed to be $0 on the X and -$2,500 on the Y axis. The Y coordinate plots fine. But instead of $0 being plotted on the X axis it is "indented slightly" and says "Point 1" when I do a mouse over the first data point.

How do I get the X coordinate to be $0, instead of being recognized as Point 1?

 

[shg]

Make sure that the x values are all numbers, and then change the chart to to xy scatter.

 

[Excel_VBA]

Make sure that the x values are all numbers, and then change the chart to to xy scatter.

Thank you for your suggestion. I tried it and I am still having the same problem. The first data point is still showing as "Point 1."

 

[Excel_VBA]

Make sure that the x values are all numbers, and then change the chart to to xy scatter.

I tried this again and it worked. Thank you very much.

 

[shg]

Perseverence pays off, good job!

You're welcome.