Z
Z
Turns out that twipstochartpart actually does do what I thought and it is
not broken. I kept getting errors trying to use it as it was shown in the
docs. The docs were the problem!
From the docs:
Identifies a chart part by using the x and y set of coordinates on to
identify that part.
Syntax
object.TwipsToChartPart (xVal, yVal, part, index1, index2, index3, index4)
The TwipsToChartPart method syntax has these parts:
<snip>
if you use it as shown, you get an error saying it wants to be equated to
something, e.g.
ObJectTHingy=MSChart.TwipsToChartPart (xVal, yVal, part, index1, index2,
index3, index4)
Which gives a type mismatch.
Fact is you have to use it without brackets and not assigning to anything.
You supply X and Y, it fills in the rest, e.g.
MSChart.TwipsToChartPart xVal, yVal, part, index1, index2, index3, index4
not broken. I kept getting errors trying to use it as it was shown in the
docs. The docs were the problem!
From the docs:
Identifies a chart part by using the x and y set of coordinates on to
identify that part.
Syntax
object.TwipsToChartPart (xVal, yVal, part, index1, index2, index3, index4)
The TwipsToChartPart method syntax has these parts:
<snip>
if you use it as shown, you get an error saying it wants to be equated to
something, e.g.
ObJectTHingy=MSChart.TwipsToChartPart (xVal, yVal, part, index1, index2,
index3, index4)
Which gives a type mismatch.
Fact is you have to use it without brackets and not assigning to anything.
You supply X and Y, it fills in the rest, e.g.
MSChart.TwipsToChartPart xVal, yVal, part, index1, index2, index3, index4