Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating links on the bars of a bar graph
Hello!
I want to provide links on the bars of a bar graph. Say, if a bar graph has 5 bars, I would like to place a hyperlink in each of those 5 bars. And each hyperlink would take me to a different worksheet. Please let me know if this is really possible! Regards, Ankur |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating links on the bars of a bar graph
You can do it using chart events. It requires a little bit of VBA
programming. This article explains how to set up chart events. Where it shows how to identify the point clicked on by the user (about halfway through), rather than pop up a message box with information about the point, activate the desired worksheet. http://www.computorcompanion.com/LPMArticle.asp?ID=221 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ps.com... Hello! I want to provide links on the bars of a bar graph. Say, if a bar graph has 5 bars, I would like to place a hyperlink in each of those 5 bars. And each hyperlink would take me to a different worksheet. Please let me know if this is really possible! Regards, Ankur |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
how do I get the bars on my graph to match the cell color | Charts and Charting in Excel | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
Creating links to graphic file | Excel Discussion (Misc queries) | |||
Creating links to a worksheet on a network. | Excel Worksheet Functions |