Hyperlinks from Bar Charts

[Mark Stephens]

Does anyone know if it possible to draw a bar chart and then program it to
assign a certain hyperlink to each bar. What I want to do is dynamically
link the bar chart to a line graph that corresponds to it. Thanks for your
help, Mark

 

[Stephen Bullen]

Hi Mark,

Does anyone know if it possible to draw a bar chart and then program it to
assign a certain hyperlink to each bar. What I want to do is dynamically
link the bar chart to a line graph that corresponds to it. Thanks for your
help, Mark

There's nothing built in, but in theory, it should be possible to trap the
MouseDown event in the chart's code module, identify which bar the mouse is
over (if any), then activate the sub-chart yourself.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie