Can you create links from part of a graph in excel to drill down? For
example, in Adobe, you can set up a link so that a given bar when touched
triggers a link to another chart. Can this be done in Excel?
Can you create links from part of a graph in excel to drill down? For
example, in Adobe, you can set up a link so that a given bar when touched
triggers a link to another chart. Can this be done in Excel?
Yes, it can be done by using a textbox, and assigning a hyperlink to this.
Select your chart and click the textbox icon on Drawing toolbar. Put the
textbox in the chart where you want it and type for instance "Link". Select
the textbox and click it again so you see the textbox border get a different
appearance (to a finer dotted border). In the menu Insert/Hyperlink choose
"Place in this document" and the rest is more or less automatic. (Trick: you
can make the textbox transparent so it effectively becomes a hot spot in your
chart)
Good luck,
Henk
"daigle" wrote:
> Can you create links from part of a graph in excel to drill down? For
> example, in Adobe, you can set up a link so that a given bar when touched
> triggers a link to another chart. Can this be done in Excel?
A more complicated but more powerful technique is to use chart events that
detect which point on the chart was clicked on, and activate one of several
other charts.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"HEK" <[email protected]> wrote in message
news:[email protected]...
> Yes, it can be done by using a textbox, and assigning a hyperlink to this.
> Select your chart and click the textbox icon on Drawing toolbar. Put the
> textbox in the chart where you want it and type for instance "Link".
> Select
> the textbox and click it again so you see the textbox border get a
> different
> appearance (to a finer dotted border). In the menu Insert/Hyperlink choose
> "Place in this document" and the rest is more or less automatic. (Trick:
> you
> can make the textbox transparent so it effectively becomes a hot spot in
> your
> chart)
> Good luck,
> Henk
>
> "daigle" wrote:
>
>> Can you create links from part of a graph in excel to drill down? For
>> example, in Adobe, you can set up a link so that a given bar when touched
>> triggers a link to another chart. Can this be done in Excel?
I like HEK's idea but would like more information on these Chart events as
well. Can you elaborate?
Thanks!
"Jon Peltier" wrote:
> A more complicated but more powerful technique is to use chart events that
> detect which point on the chart was clicked on, and activate one of several
> other charts.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "HEK" <[email protected]> wrote in message
> news:[email protected]...
> > Yes, it can be done by using a textbox, and assigning a hyperlink to this.
> > Select your chart and click the textbox icon on Drawing toolbar. Put the
> > textbox in the chart where you want it and type for instance "Link".
> > Select
> > the textbox and click it again so you see the textbox border get a
> > different
> > appearance (to a finer dotted border). In the menu Insert/Hyperlink choose
> > "Place in this document" and the rest is more or less automatic. (Trick:
> > you
> > can make the textbox transparent so it effectively becomes a hot spot in
> > your
> > chart)
> > Good luck,
> > Henk
> >
> > "daigle" wrote:
> >
> >> Can you create links from part of a graph in excel to drill down? For
> >> example, in Adobe, you can set up a link so that a given bar when touched
> >> triggers a link to another chart. Can this be done in Excel?
>
>
>
Nevermind, I found it on your website. Thanks!
"daigle" wrote:
> I like HEK's idea but would like more information on these Chart events as
> well. Can you elaborate?
>
> Thanks!
>
> "Jon Peltier" wrote:
>
> > A more complicated but more powerful technique is to use chart events that
> > detect which point on the chart was clicked on, and activate one of several
> > other charts.
> >
> > - Jon
> > -------
> > Jon Peltier, Microsoft Excel MVP
> > Tutorials and Custom Solutions
> > http://PeltierTech.com
> > _______
> >
> >
> > "HEK" <[email protected]> wrote in message
> > news:[email protected]...
> > > Yes, it can be done by using a textbox, and assigning a hyperlink to this.
> > > Select your chart and click the textbox icon on Drawing toolbar. Put the
> > > textbox in the chart where you want it and type for instance "Link".
> > > Select
> > > the textbox and click it again so you see the textbox border get a
> > > different
> > > appearance (to a finer dotted border). In the menu Insert/Hyperlink choose
> > > "Place in this document" and the rest is more or less automatic. (Trick:
> > > you
> > > can make the textbox transparent so it effectively becomes a hot spot in
> > > your
> > > chart)
> > > Good luck,
> > > Henk
> > >
> > > "daigle" wrote:
> > >
> > >> Can you create links from part of a graph in excel to drill down? For
> > >> example, in Adobe, you can set up a link so that a given bar when touched
> > >> triggers a link to another chart. Can this be done in Excel?
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks