Hyperlink Individual Chart Segment/Element

[2696883]

Is there any way to link insert a hyperlink to an individual chart element? I have several pie charts that I want to link to each other - so if one chart shows a breakdown of data by regions, clicking on a particular region will link to a second chart that breaks down the data by countries in that region.

I can link the entire chart to a different worksheet through using the following code:

ActiveSheet.ChartObjects(1).Activate
ActiveChart.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:="", SubAddress:="'Regions'!A1"

However this only links the entire chart, and not an individual segment or element.

 

[Luke M]

I don't think you can do it with Hyperlinks, but if the chart is on it's own Chart Sheet, you can use the Chart_Select macro, and then detect which element is selected.

 

[NARAYANK991]

Hi ,

See these links :

1. http://www.mrexcel.com/forum/excel-questions/176175-can-i-hyperlink-pie-chart-segments.html

2. http://www.tushar-mehta.com/excel/software/pivotchart/

The technique uses classes , and is explained here :

http://peltiertech.com/WordPress/chart-event-class-module-to-highlight-a-series/

http://peltiertech.com/WordPress/tag/chart-events/

Narayan