+ Reply to Thread
Results 1 to 5 of 5

Interactive Charts

  1. #1
    daigle
    Guest

    Interactive Charts

    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?

  2. #2
    HEK
    Guest

    RE: Interactive Charts

    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?


  3. #3
    Jon Peltier
    Guest

    Re: Interactive Charts

    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" <HEK@discussions.microsoft.com> wrote in message
    news:E079227B-A805-40EB-B4D0-D0CD53B7E97A@microsoft.com...
    > 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?




  4. #4
    daigle
    Guest

    Re: Interactive Charts

    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" <HEK@discussions.microsoft.com> wrote in message
    > news:E079227B-A805-40EB-B4D0-D0CD53B7E97A@microsoft.com...
    > > 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?

    >
    >
    >


  5. #5
    daigle
    Guest

    Re: Interactive Charts

    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" <HEK@discussions.microsoft.com> wrote in message
    > > news:E079227B-A805-40EB-B4D0-D0CD53B7E97A@microsoft.com...
    > > > 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?

    > >
    > >
    > >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1