Hello fellow excel users,

I have a 2 variable chart of data done from some tests.

In the 'X' column i have number of connections,
1, 4, 8, 16, 32, 64

in the 'Y' Column i have throughput,
35.16, 110, 110, 110, 121, 121,



What I'm looking for is a way to expand my X column to be every single connection,
1, 2, 3, 4, 5, 6.........62, 63, 64

And have my 'Y' column data automatically filled in as well via some sort of extrapolation from the previous data.

Thanks in advance.