Forum Discussion

Lockie330's avatar
Lockie330
Copper Contributor
Jun 18, 2022

Interpopulation of data

Hi All,

 

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?

 

Excel on Mac
office 365
training
  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Jun 29, 2022

    HI Lockie330 


    Hopefully, I understand your question. Let me explain what I did enter data in 3 columns X, Y, and Z.

    X column data map on the x-axis and Y column data mapping on the y-axis and if you notice Z column data mapping with circle size in the chart.

     

    You can create using Microsoft Excel & Office 365.

     

    And if you are comfortable with Google Sheets, you can find it here.

     

    Image:

     

    Thanks

     

     

     

Resources