Clickable Bar Charts

[schnoogle]

Hi everyone,
I am new here, and would love your help.

I have a clustered bar chart and I want to be able to click on
portion of a bar, and have a pop-up message box appear lists th
contents of some worksheet cells (the cells that contain the data tha
comprise series of the bar chart clicked).

How can I generate a pop-up MsgBox that contains cell info dependen
which bar of a bar chart is pressed?

I am not good at VBA, so if someone could give me some help with th
code taht would be great.

Thanks heaps in advance for your hel

 

[Jon Peltier]

I have some lightly documented code on my site that help you determine which point
was clicked on, so you could pop up a custom message:

http://peltiertech.com/Excel/Zips/GetXYonaChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

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