Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default GET.CHART.ITEM returning strange results

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,
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Functions - Strange results Bob Excel Worksheet Functions 3 June 8th 06 08:48 PM
Vlookup Returning Same Results on Each Row tlatta Excel Discussion (Misc queries) 0 December 14th 05 07:34 PM
Vlookup Returning Same Results on Each Row Kleev Excel Discussion (Misc queries) 0 December 14th 05 07:33 PM
Strange Results with Autofilter Joyce Excel Discussion (Misc queries) 1 January 17th 05 02:42 AM
Returning the last item in column HondaMike New Users to Excel 3 January 4th 05 11:20 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"