Any way to have an active hyperlink in an Excel web chart?

[gkoehler]

I publish Excel charts as web pages.
e.g
http://pmo.umext.maine.edu/apple/AllModels/MEmodel/ME-Monmouth-HourChart.htm

The charts have associated background pages that I would like web users
to be able to reach from hyperlinks built into the chart. But I have
not been able to find a way to insert an active hyperlink into an Excel
chart. Any help appreciated.

 

[Ed Ferrero]

Hi,

I don't think you can publish a hyperlink within a chart sheet.
But you can place the chart as an embedded object on a worksheet
and then place hyperlinks on the worksheet.
Publish the whole sheet and you will have working hyperlinks
with the chart. If you want the links to appear within the chart,
place the link in a textbox and move the textbox over the chart.

 

[Tushar Mehta]

Insert a textbox in a chart and hyerlink that textbox.

To insert a textbox in a chart, select the chart and type something
into the formula bar. XL will create a textbox embedded in the chart.
Now, select the textbox, and then select Insert | Hyperlink... (or
CTRL+k). Set the bookmark as desired.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

Ed Ferrero pointed out in an email that my suggestion doesn't work for
a chart published to a web page. Oops! And, I shouldn't have expected
it to since XL publishes a chart as a graphic image. Double oops!

So, if you are pubishing a static page as in your example, it would
appear your choice would be to edit the resulting image with a program
such as FrontPage and add 'hotspots' to the image. A hotspot as
defined by FP is an area on an image that is hyperlinked to somewhere.
Of course, that requires human intervention every time the chart is
created.

Unless, you use predetermined areas for the hotspots that are not
sensitive to the graphical display itself, e.g., create a link from the
legend area.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions