OWC10: Using Series.ValueToPoint in c#

[Alfredo Morales]

Hi:

I am trying to get the coordinates of an element in a
series using Series.ValueToPoint method. I reimplemented
parts of the example on Microsoft Knowledge Base Article -
290348 (http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/q2
90/3/48.asp&NoWebContent=1) to try the functionality
before I went into my app. In the example you get a
coordinate by using the following:

Set oPoint = oChart.SeriesCollection(0).Points(nMinPoint)
Set oCoord = oChart.SeriesCollection(0).ValueToPoint( _
oPoint.GetValue(c.chDimCategories), oPoint.GetValue
(c.chDimValues))


When I tried to translate this statements into c#, the
method ValueToPoint requires three parameters - the API
reference, which is written for VB says, that the 3rd
paramater is only needed if you are working with a 3D
graph. I tried several things to make this work in c#(many
of them just plain stupid - passing null, "", 0,
false, ...) All of them producing the same error:

"Invalid Parameter"
Microsoft.Office.Interop.OWC.ChSeries.ValueToPoint(Object
xvalue, Object yvalue, Object zvalue)

hResult = -2146827284

Has anybody encounter this problem in the past? How can I
go around it>

I am using Office XP Tool: Web Components
( http://www.microsoft.com/downloads/details.aspx?
FamilyID=982B0359-0A86-4FB2-A7EE-
5F3A499515DD&displaylang=en) and I already setup the
Office XP Primary Interop Assemblies. This is running in a
Win2000 Server with .Net Framework 1.1.

 

[Alvin Bruney [MVP]]

chdimvalues represents the data on the value axes (loosely it would be the
y-axis, though not always as some graphs have no notion of x/y-axes).