Excel 2007 : How to generate a uniform excel output from irregularly sampled data

Hi,
I have two issues with EXCEL2007:
1. How to generate a uniformly sampled data sheet from following example table:
X Y
12.4 51
42.4 77
87.5 92.8
117.4 104.6
132.4 109.8
162.5 122.4
192.3 133.2
222.5 142
252.5 152.2
I need to have a table with column having data every 50 units or every 100units. For example using moving average trend line etc or through any other method.
2. In the scatter plot I want to annotate the samples with the labels a, b, c, d etc for the following table:
Label X Y
a 12.4 51
b 42.4 77
c 87.5 92.8
d 117.4 104.6
e 132.4 109.8
f 162.5 122.4
g 192.3 133.2
h 222.5 142
i 252.5 152.2

Any help highly appreciated.

Regards,

Rao

You could use LINEST to regress the data in any of several ways, and then use those results to compute Y for a given value of X. Or you could use a function to interpolate between values:

Please Login or Register  to view this content.

Here's the function:

Please Login or Register  to view this content.

Add the code to a code module as described below, and then enter the formula as shown in the example.

Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

You're welcome.

Any suggestions for ...

Yes -- start a new thread in the Charting forum.