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

  • Thread starter Thread starter gkoehler
  • Start date Start date
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.
 
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
 
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
 
Back
Top