Anyone know how to create a hyperlink inside an Excel pie chart?
Anyone know how to create a hyperlink inside an Excel pie chart?
|
Anyone know how to create a hyperlink inside an Excel pie chart?
Hi,
You will have to capture mouse clicks via the chart events, see Jon Peltier's explanation. http://www.computorcompanion.com/LPMArticle.asp?ID=221 To mimic the the hyperlink use something like, Activeworkbook.FollowHyperlink [address] Cheers Andy HyperChart wrote: Anyone know how to create a hyperlink inside an Excel pie chart? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Anyone know how to create a hyperlink inside an Excel pie chart?
Yes.
Create the pie chart, (I always use 'insert as new sheet' option). Draw a text box onto the pie chart and type in the web address. I then selected the text box ( so I got the dots around the text box not the lines) and right-clicked and the Hyperlink option was there. You can type the URL into the normal place as you would for any hyperlink. After this, any time I did a new text box and typed in a www. URL it automatically recognised it and I didn't have to right-click and select Hyperlink. Hope this helps? "HyperChart" wrote: Anyone know how to create a hyperlink inside an Excel pie chart? |
All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com