hi,
is there a way to use a chart object as an anchor for a hyperlink in vba? probably using the statement activesheet.hyperlinks.add anchor:=... and so on.
i believe shape objects can be used as anchors, and i am trying to refer to the chart object as a shape, but so far it has not worked.
any help will be very appreciated!
thank you,
kriti

Info from:

http://pubs.logicalexpressions.com/P...?ID=209#jon016

Hyperlink to a Chart

Hyperlink to an Embedded Chart

You can't hyperlink to a chart directly, but you can link to a cell on the worksheet in which the chart is embedded. Use the cell under the top left corner of the chart, or the entire range under the chart.

Hyperlink to a Chart Sheet

You can't hyperlink to a chart directly, and a chart sheet has no underlying cells you can link to. You can fake it with a Worksheet_SelectionChange event procedure, however. In this example, the hyperlink is in cell B2. Enter the name of the chart sheet in cell B2, and format it with blue underlined text, so it looks like a real hyperlink. Right click on the sheet tab, select View Code, and paste this macro into the code module that
appears:

  Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
      If Not Intersect(Target, Range("B2")) Is Nothing Then
           Cancel = True
      End If
  End Sub

  Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      If Not Intersect(Target, Range("B2")) Is Nothing Then
           On Error Resume Next
           Charts(Target.Value).Activate
           If Err.Number <> 0 Then
               MsgBox "No such chart exists.", vbCritical, _
                     "Chart Not Found"
           End If
           On Error GoTo 0
      End If
  End Sub

When the user selects cell B2, the procedure is activated. The code jumps to the sheet with the name in the cell. If it can't go to that sheet, it assumes it's because the sheet doesn't exist, and it alerts the user.

hi,
thanks so much for your reply, but i need to hyperlink FROM a chart, not TO chart. i.e., i need the chart to be the link, not the destination of the link. any thoughts in that area?
kriti

Hi,
Of course it was my mistake.
I hope that this solution will be better and help You. In this case chart works like "button" which opens i.e Web site.
In new workbook (Sheet1) I made chart.
In VBA I inserted Class Module (its name KAZIK) and wrote this code:

Public WithEvents myChartClass As Chart
Option Explicit


Private Sub myChartClass_MouseDown()

ActiveWorkbook.FollowHyperlink Address:="http://www.google.pl/", NewWindow:=True

End Sub

Next I wrote code in This Workbook:

Dim SummaryChart As New KAZIK
Option Explicit

Private Sub Workbook_Open()
    Range("A1").Select
    Set SummaryChart.myChartClass = Worksheets(1).ChartObjects(1).Chart
End Sub



Kazik