link from chart data point to data (mousedown)

[Guest]

Hi
I want to link all the points in my xychart with the rows of the data that are in the chart. i.e. after a mouseclick on the chart data the user will be redirected to the data row
The idea is to create a link to a text cell, situated in the same row as the data, which explains the details to each point

Thanks in advance for your help
Mattias

 

[K Dales]

Great idea, but not easy to do...

There are no Event Procedures for Chart Series or Points
in an Excel Chart - just for the Chart itself. In other
words, you will not be able to get any Excel VBA code to
recognize when a certain point has been clicked, at least
not easily...

It seems to me it COULD be done by using the Click (or
MouseDown) Events of the Chart Object - but then you would
need code to find the location of your mouse pointer and
the nearest point on your chart and... well, you see it is
getting quite complex and very technical - would probably
need some Windows API functions to make it all work.

Kind of wish I had the time to work on this, since it
would be a very useful feature!

K Dales

-----Original Message-----
Hi,
I want to link all the points in my xychart with the rows

of the data that are in the chart. i.e. after a mouseclick
on the chart data the user will be redirected to the data
row.

The idea is to create a link to a text cell, situated in

the same row as the data, which explains the details to
each point.

 

[Andy Pope]

Hi,

Jon Peltiers's examples may prove useful here.
(http://peltiertech.com/Excel/Charts/chartvba.html#PointInfo)

Cheers
Andy

 

[Guest]

In addition to the other comments you have received you might want to check the Excel/Add-Ins/Hover Chart Label page of my web site.

 

[Tushar Mehta]

Sorry about the missing web site address. It is in the signature
below.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions