Clickable Bar Charts

  • Thread starter Thread starter schnoogle
  • Start date Start date
S

schnoogle

Thank you very much for your help. Your excellent examples have hal
helped me - but unfortunately because I am just beginning to teac
myself this, I am not sure what to do now.

I need the following:

********
If ElementID = xlSeries Then
If Arg2 > 0 Then
MsgBox "Series " & Arg1 & vbCrLf _
& SeriesCollection(Arg1).Name & vbCrLf _
& "Point " & Arg2 & vbCrLf _
& "X = " & WorksheetFunction.Index _
(SeriesCollection(Arg1).XValues, Arg2) & vbCrLf _
& "Y = " & WorksheetFunction.Index _
(SeriesCollection(Arg1).Values, Arg2) & vbCrLf & vbCrL
_
& "Any questions?"
Else
MsgBox "Select a single point, please", vbInformation, "Pick
Point"
End If
End If
End Sub

******

...to have a msgBox (or something similar) that pops up with the sourc
data for that point (from a spreadsheet). Like when you click on a poin
on the chart it will pop up with the value of cells A2, or A3, dependin
on which point on the chart was clicked.

Can anyone please give me any pointers?

cheers


Can anyone please hel
 
I'm not sure what you're asking for that's different from what the sample files
provide. Could you explain in more detail?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top