Linking Chart items to files

[Guest]

Anyone got a clue on how to link
each stacked bar(or similar) to a different
file, so when someone views the file, he can
click on the bar, to get a relevant document
on his web-browser/similar(pdf, whatever).
Any suggestions?

 

[Jon Peltier]

You can write event procedures that determine which point was clicked.
Within the procedure you need some kind of lookup to see what document
should be launched according to the point which was clicked.

Here's an article on chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

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