Please see the attached chart.
I am presented data in the form of the first table (Input Limits) and I want to plot this data as shown in the chart.
To do this the data has to be converted into the plot points in the second table (x and y values).
Is there a way of writing a formula that would create this second table from the first? Or...
I know how to create the required plot points and list them horizontally next to the associated data (Input Limits) as in the third table but then the chart can not plot them. Is there a way to get this chart to plot with the plot points listed horizontally?