Series Hyperlink or something like it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi people

I have created a new chart-sheet with 3 series on it. What I wanted to do is that when i click on the series, i will want the excel to run another piece of codes and generate another graph that is related

I do not know whether it's possible but if not is there anyway i can make any "interaction" such as using dialog box, msgbox when click on the chart

One more thing i need to remind, is that the charts are generated from codes, not plotted manually. So there is no way to code in the charts before it's generated

Thank You
 
Kaiyang -

You can have a class module in the workbook that enables chart events:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213738

It usually is used for events in embedded charts, which are not backed
up by a code module in the workbook's VBA project. But it can be applied
to chart sheets as well. In step 8 of the MSKB article, use this code
instead:

Sub Set_Chart()
Set mychart.EmbChart = ActiveChart
End Sub

You could alternatively set up an application events class that, when a
sheet is activated, enables events for the chart (if it's a chart sheet)
or for any embedded charts on the sheet (chart sheet or worksheet).

You could also have your code write the chart event procedure behind the
chart sheet it creates.

Finally you need an event procedure in the chart events class module
that detects a click on a series or point:

Private Sub EmbChart_Select(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long)
MsgBox "You've selected chart element " & ElementID & _
" (" & Arg1 & ", " & Arg2 & ")."
End Sub

If ElementID is that of a series, Arg1 is the series number and Arg2 is
the point. I have some of this on my web site:

http://peltiertech.com/Excel/Charts/chartvba.html#PointInfo

- Jon
 
Back
Top