Points Dimensions on a 3D Clustered Column Chart

[Edgar]

Hi,
Need some valuable help on this:
I' ve got a 3D Clustered column Chart. I'd like to have the coordinates for
each point in a particular series. It's like when you move the mouse over any
point, it shows you a tip with the value and the name for that point. Well I
Need to have control on those coordinates to show a ListBox on top of the
chart showing specific information according to the point the mouse is moving
on.
I've been going through this trying to find any tips but the information i
got reffers to a 2D an scatter Charts, with 2 axis.

Really appreciated thanks are giving in advance

 

[Jon Peltier]

The MouseMove and related events reveal these coordinates, if you base the
display of the notation on user events. The coordinates are related to
so-called chart coordinates, that is, pixels from the top left of the chart.
You would have to convert that to points in order to position the listbox or
textbox properly.

If you want to position objects on the chart in the absence of mouse events,
you can determine positions using algebra or other mathematical tools. This
is complicated by the use of a 3D chart type.

- Jon

 

[Edgar]

Hi Jon,
Maybe Complicated but there it is and works, cause when you move the mouse
over a single point, it shows the series name and the point value. (When
showtipsvalue and name are available).
If any mathematical function you know to manage that, I'd appreciate it.

 

[Peter T]

There is no simple mathematical function, as Jon mentioned it's maths.

If, as you say, you've already worked out how to get the point co-ord's for
a 2d all you need to do is work out the "diagonal" XY offset for each point
in the 3d. If the chart has the third Series-Axis your work is almost done.

with cht.axes(3)
xz = .width / no of series
yz = .height / no. of series
end with

idx = series-index
xzf = xzf * ( idx - 0.5)
yzf = yz * (idx - 0.5)

As written assumes the series-axis is on the right, sloping from bottom left
to top right and the other axes are in "typical" positions, if not some more
adjustments required.

Add xzf and yzf respectively to your XY point co-ord's

Regards,
Peter T