Excel formula expert
Budget: €30 – €250 EUR
So I have some data X,Y,Z.
I want to make a chart 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 excel would work out the blank values for me.
Any ideas on how to do this or if it is possible?
I want to make a chart 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 excel would work out the blank values for me.
Any ideas on how to do this or if it is possible?