Hi Andy-

I was vigilant about trying different formats (text, general, number)... but nothing seems to work. As you can see in this screenshot, the value for Y defaults to 1. Over and over, I go in and change this to represent my actual Y-axis data. However, it just goes back to Y=1 no matter what.
Again, if I type in by hand, it doesn't do this.

Excel screenshot.jpg