Hi Mark,

Can you not adapt the chart event codes you already have from your
previous posts?

If you go with the invisible covering shape why not simply cover the
whole chart and then work out what is under the mouse rather than having
multiple covers.

Cheers
Andy

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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info