Since I don't use 3D charts, I have not tried to do this kind of
calculation.

I had a thought. In Excel's old XLM language, you could determine the
coordinates of an element in the active chart. For example, to find the X-Y
coordinates of the top left corner of series 1, point 1 in a 2D column
chart:

X = ExecuteExcel4Macro("get.chart.item(1,1,""s1p1"")")
Y = ExecuteExcel4Macro("get.chart.item(2,1,""s1p1"")")

Works great in a 2D chart. I tried in a 3D chart, and Excel returned Error
2015, or #VALUE! So I guess it's even too hard for Excel to compute.

Any particular reason you need a 3D chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Edgar" wrote in message
...
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.
--
Edgar Rey


"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Edgar" wrote in message
...
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
--
Edgar Rey