Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Database Functions - Strange results | Excel Worksheet Functions | |||
Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) | |||
Vlookup Returning Same Results on Each Row | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Returning the last item in column | New Users to Excel |