Thread: The reference is not valid error message for data - but the same ones appear to exist

I will attach a copy of a chart I use for flow testing fire pumps. The data series for "Previous" and "MFG" work fine but the data for "Current Test Data" has the X and Y value series backwards. When I try to edit them to reverse this I get the error message in the subject line, yet the data seems correct.

I'm sure I've run into this and solved it before but it's really got me baffled right now.Flow Test Example.xlsx

Hi,
The data in column L and O are reversed
Net pump pressure (PSI) : 74, 71, 60 instead of 0, 300, 450
Flow (GPM) : 0, 300, 450 instead of 74, 71, 60
Hope this helps
Best regards