Hyperlinks from Bar Charts
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 |
Hyperlinks from Bar Charts
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 |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com