Dynamic Range and series in XY Scatter

Hello,

I am attempting to make a calculator that creates a XY scatter graph from an array of values. I am running into a few issues.

The array is constructed using the inputs from the user, and as such the size of the array varies. At present I have selected the entire array to be graphed regardless of if it contains any values. I believe this is creating issues with my x-axis presenting the correct values.

Another undesirable result of this is that as the entire array is being graphed, series that contain no data are also graphed and appear in the legend.

Is there anyway I can create an XY graph that is dynamic in determining the size of the array? And will this rectify my issue? Or is there an entirely different approach that may help?

The spreadsheet I have built to do this is attached. I apologise that the inputs and output graph are located on a separate sheet to the data used to create the array, I did this to streamline the experience for the user.

For reference, the user inputs highlighted in yellow are those that result in the variation in array size.

I thank you in advance for any help you may be able to provide.

Kind Regards
Braedos