Mark,

Judging from what you've described, you might have already gone through this
process. In any event I've documented the process of creating clickable bars
- maybe it can help.

http://www.pdbook.com/index.php/exce...ble_bar_chart/

--
Regards,
John Mansfield
http://www.pdbook.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