OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Charts and Charting (http://www.officefrustration.com/forumdisplay.php?f=8)
-   -   How do I insert a hyperlink into a chart element? (http://www.officefrustration.com/showthread.php?t=1119366)

js June 4th, 2010 03:30 AM

How do I insert a hyperlink into a chart element?
 
How can I insert a hyperlink into a bar of a bar chart, for instance? I read
on MSFT's help page that, "You can also insert hyperlinks in specific chart
elements.", but I cannot figure out how to do so.

Jon Peltier[_2_] June 5th, 2010 08:12 PM

How do I insert a hyperlink into a chart element?
 
It's not so easy. You need to set up code to recognize chart events,
then respond to the specific event. This article described chart events
in Excel charts:

Chart Events in Microsoft Excel
http://www.computorcompanion.com/LPMArticle.asp?ID=221

Search the page for a paragraph beginning with this sentence:

"Identify the clicked point, then jump to another appropriate chart."

The situation you are asking about is described here.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 6/3/2010 10:30 PM, JS wrote:
How can I insert a hyperlink into a bar of a bar chart, for instance? I read
on MSFT's help page that, "You can also insert hyperlinks in specific chart
elements.", but I cannot figure out how to do so.



All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com