View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Points Dimensions on a 3D Clustered Column Chart

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