Mark -

You can use the techniques in this article to capture chart events, such as clicking
on a bar in a bar chart:

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

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

Mark Stephens wrote:

Is there a way to make the bars on a bar chart clickable. I can get the
functionality by coverin g them with an invisible shape but the problem is
that the size of the graph changes with changed data and so the covers don't
fit over the bars when it rescales. Another alternative I have thought could
work is to somehow measure the distance between vertical gridlines and then
draw a shape to the psecified dimension and align it to the x axis - pretty
complicated don't know if that could be done.

Any ideas much appreciated, kind regards, Mark