If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Anyone know how to create a hyperlink inside an Excel pie chart?
Anyone know how to create a hyperlink inside an Excel pie chart?
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do i create a user defined chart in Powerpoint or excel? | Magnus | Charts and Charting | 1 | December 7th, 2005 04:52 PM |
How to create a line chart with two X-axes in Excel | JaVaughn | General Discussion | 2 | June 29th, 2005 04:52 PM |
excel chart size using inside positioning | Travis | Charts and Charting | 2 | February 15th, 2005 04:10 AM |
How do I create an Excel chart with data from separate workbooks? | Andy | Charts and Charting | 3 | September 24th, 2004 01:11 AM |
May you help me? output data MS Access query to excel and create chart. | slim004 | Charts and Charting | 1 | May 14th, 2004 11:34 AM |