Click on labels to hyperlink?

[Dan Tabla]

Thanks to this forum I learned how to add labels to my charts but I don' t
know how to attach Hyperlinks to my labels!!!

 

[Shane Devenshire]

Hi,

I don't think you can attach a hyperlink to a data label. You can attach
hyperlinks to text boxes on chart.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Dan Tabla]

I don't know how to add a text box on a chart.

Hi,

I don't think you can attach a hyperlink to a data label. You can attach
hyperlinks to text boxes on chart.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Andy Pope]

Hi,

You can not apply hyperlinks to the data labels but with some VBA you
can hook into the chart events and mimic a hyperlink.

create a chart and right click the sheet tab. Pick View code and then
post the following.

Private Sub Chart_Select(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long)

If ElementID = xlDataLabel Then
If Arg1 = 1 Then
If Arg2 = 2 Then
' selected 2 datalabel of series 1
ActiveWorkbook.FollowHyperlink "http:\\" _
& ActiveChart.SeriesCollection(Arg1).DataLabels(Arg2).Text
End If
End If
End If

End Sub

You can find more information on chart events here
http://www.computorcompanion.com/LPMArticle.asp?ID=221

To add a text box select the chart and just type something. It will
automatically add a textbox. You can then add a hyperlink to that.

Cheers
Andy

 

[Dan Tabla]

Thank you so much Andy and Shane .
You realy helped me. I'm doing VBA code. Any advice how/where to start
taking classes doing it organized/profesionaly because right now I'm doing it
randomly to improve my office work production!