title: Excel Chart Hyperlink
body: <p>I use the following code to add a hyperlink to a chart, linking it to a different worksheet:</p>
  
  <pre><code>ActiveSheet.ChartObjects("Chart 3").Activate
  ActiveChart.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:="", SubAddress:= _
      "'Sheet2'!A1"
  </code></pre>
  
  <p>However this creates a link that is activated when clicking on the entire chart. The pie chart has 4 segments (each relating to a different series) and I would like each segment to link to a different worksheet. So the first segment will go to Sheet2, the second segment to Sheet3 and so on. </p>
  
  <p>Is there a way to add an anchor to each individual segment rather than to the entire chart as a whole?</p>