LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked/clustered column chart with a two vertical axes [email protected] Charts and Charting in Excel 2 March 19th 07 08:40 PM
Needed: Chart that combines clustered column and stacked column types Gerry Charts and Charting in Excel 3 February 14th 07 02:53 AM
Combined: Clustered-Stacked Column Chart cdo Charts and Charting in Excel 1 August 31st 05 01:46 AM
combination clustered column and stacked bar chart John Charts and Charting in Excel 2 April 19th 05 03:49 PM
Clustered column chart with stacked coumns Dave Charts and Charting in Excel 1 January 4th 05 10:40 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"