GET.CHART.ITEM returning strange results

[Laura Battarbee]

I have some functionality written in VB that I am re-writing in C#, but I am
getting a different result from the GET.CHART.ITEM macro for the exact same
chart series point. This is running in Excel 2003.

An example:

VB CODE: --> result is 337.5

Dim returnValue as variant

Series.points(1).select

returnValue = Application. ExecuteExcel4Macro("GET.CHART.ITEM(1,1)")

C# CODE: --> result is 309.25

Series.points(1).select

object returnValue = _application.ExecuteExcel4Macro(("GET.CHART.ITEM(1,1)");

Another interesting note is that I run the same C# code on the same chart
point in Excel 2007 and I get another result again! (196)

I understand this macro to be the following:

/*

*GET.CHART.ITEM (x_y_index, point_index, item_text)

*

* Returns the vertical or horizontal position of a point on
a chart item.

* Position is measured in points; a point is 1/72nd of an
inch.

*

* x_y_index 1=horizontal 2 = vertical

* point_index 1=lower 2 = upper or right

* item_text i.e. "PLOT" would be the plot area. We
leave this out so it takes the selection

*/

So I should be getting the horizontal lower point of the selected point in
the series.

Why would I be getting different results?

Thanks,