Hi Nick,
Greetings! Thank you for posting to Microsoft Community.
It could be column and row are in wrong position like below:
Click Switch row/column, then it will work.
If my understanding above is not consistent with yours, feel free to point that out.
Best Regards,
Snow Lu