Can I place a Hyperlink in an Excel chart?

[rio0131]

Is it possible to place a hyperlink within an Excel chart that, when clicked, will take the operator to a specific location in the source Excel worksheet?
What I really want to do is place the Excel chart in a PowerPoint presentation and have users of the information be able to trace back to the source data.

Thanks,
Nancy in Anchorage, Alaska

 

[Scott Huish]

Not sure if this will work for what you are doing, but in a roundabout way, yes you can put a hyperlink on a chart.

1. Put the actual hyperlink in a cell hidden behind the chart. In this example, I use cell H14.
2. Put a label control on the chart, put the text you want for the hyperlink in the Caption property. Select Underline on Font Property. Select Blue from the System pallette in ForeColor Property
3. In the Label Click event:

Private Sub Label1_Click()
ActiveSheet.Range("H14").Hyperlinks(1).Follow
End Sub

 

[rio0131]

First, let me thank you for answering.
But, I should've told you - I'm an Excel novice! And you lost me after point #1. I don't know what a label control is - once I figure that out, I'm guessing the Label Click event will be easily found.

Could you help me in finding the Label Control?

Thanks,
Nancy in Anchorage, Alaska

 

[Scott Huish]

First you want to make sure your Control Toolbox Toolbar is showing.
Click on View, then Toolbars. If Control Toolbox does not have a checkbox next to it click on Control Toolbox.

You then should have a bar that looks like this. The one that is circled in red is the label control.

Click off your chart and select the label control. Then draw a rectangular shape on your chart with this tool.
Right Click on this label you just created and click on Properties.
You will then see a list of properties for this Control, this is where you will change the properties listed in Step 2.
When you are done there, you can close that box.

Right click on the label you made and click on View Code

It should say
Private Sub Label1_Click()

End Sub

Right in between those two lines, put this: (Change H14 to whatever cell you put the hyperlink in):

ActiveSheet.Range("H14").Hyperlinks(1).Follow