M
Mr.Frog.to.you
Hi Everyone,
I am building a macro to manage the labels on some data points on a
chart. In this macro I am able to work with each data point
individually, set the text and the position, the font, etc..... What I
am struggling with is determining the Y value (value) of the data
point that I am dealing with. I am attempting to check what the Y
value is via the parent object properties, and although I can see the
values in the locals viewer I cannot seem to refer to them in code.
eg/
for each p in c.SeriesCollection(i).Points
If p.Parent.Values(z) = 0 then.....
p is the point object
c is the chart (not chartobject)
i and z are counters (long), both initialised to 1 before use.
If anyone knows the correct syntax for accessing the values property
of the parent object I would be extremely grateful. The above attempt
gives me an error: (450) Wrong number of arguments or invalid property
assignment.
Cheers
The Frog
I am building a macro to manage the labels on some data points on a
chart. In this macro I am able to work with each data point
individually, set the text and the position, the font, etc..... What I
am struggling with is determining the Y value (value) of the data
point that I am dealing with. I am attempting to check what the Y
value is via the parent object properties, and although I can see the
values in the locals viewer I cannot seem to refer to them in code.
eg/
for each p in c.SeriesCollection(i).Points
If p.Parent.Values(z) = 0 then.....
p is the point object
c is the chart (not chartobject)
i and z are counters (long), both initialised to 1 before use.
If anyone knows the correct syntax for accessing the values property
of the parent object I would be extremely grateful. The above attempt
gives me an error: (450) Wrong number of arguments or invalid property
assignment.
Cheers
The Frog