So I have some data X,Y,Z.
I want to make a table where X,Y are the axis, and I give it some of the data for Z.
Now the bit that is tricky. My data of X,Y is pretty random. So I want excel to put it in to the nearest number or interpolate the number in the middle.
Example values for the chart: x values - 5,10,15,20,25,30
y values - 0,45,60,90
Data sample values: x values - 17.5,10.5,15.5,22, etc
y values - 50.3,45,38,57, etc
Ideally once I have built the chart with the known z data points the blank data points would be worked out
Any ideas on how to do this or if it is possible?