+ Reply to Thread
Results 1 to 2 of 2

Hyperlinkage of one graph with another graph or Drill down graph

  1. #1
    Sanjay Kumar Singh
    Guest

    Hyperlinkage of one graph with another graph or Drill down graph

    There is need of hyperlink of two graphs. eg.
    Graph 1:-Monthwise Equipment Downtime graph- Bar graph having Months on
    X-axis and Downtime(Hrs) on Y-Axis.
    we want to know the downtime of 10 equipment (EQ1, EQ2, EQ3, ----E12)
    monthwise (say for 12 months).This graph can be made easily.
    Graph 2:- Equipment failure by reason pie graph
    Now we want to show the pie graph for the reason of downtimes for each
    equipment (like say for EQ1:- 40%- Material failure, 30% Process failure,
    30% Design failure)
    Now we want to hyperlink graph 2 with graph 1 so that clicking on bar of
    equipment will display the failure by reason. If it is not clicked, it should
    not reflect failureby reason graph.


    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...excel.charting

  2. #2
    Tushar Mehta
    Guest

    Re: Hyperlinkage of one graph with another graph or Drill down graph

    If you are interested in something that does not require waiting for MS
    to develop a solution...

    If the result can be a PivotChart (based on an associated PivotTable),
    you could use
    PivotChart Drilldown
    http://www.tushar-
    mehta.com/excel/software/pivotchart_drilldown/index.html

    Alternatively, if you don't mind the 'breakdown reason' chart showing
    all the time, you could use a drop-down selector as in example 6 in
    Dynamic Charts
    http://www.tushar-mehta.com/excel/ne...rts/index.html

    Finally, depending on your comfort level with VBA, you could roll your
    own solution. Trap the MouseUp event for the chart, use the
    GetChartElement method to figure out which item was clicked and change
    the source of the 'breakdown details' chart appropriately.

    --
    Regards,

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

    In article <[email protected]>, =?Utf-
    8?B?U2FuamF5IEt1bWFyIFNpbmdo?= <Sanjay Kumar
    [email protected]> says...
    > There is need of hyperlink of two graphs. eg.
    > Graph 1:-Monthwise Equipment Downtime graph- Bar graph having Months on
    > X-axis and Downtime(Hrs) on Y-Axis.
    > we want to know the downtime of 10 equipment (EQ1, EQ2, EQ3, ----E12)
    > monthwise (say for 12 months).This graph can be made easily.
    > Graph 2:- Equipment failure by reason pie graph
    > Now we want to show the pie graph for the reason of downtimes for each
    > equipment (like say for EQ1:- 40%- Material failure, 30% Process failure,
    > 30% Design failure)
    > Now we want to hyperlink graph 2 with graph 1 so that clicking on bar of
    > equipment will display the failure by reason. If it is not clicked, it should
    > not reflect failureby reason graph.
    >
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/comm...excel.charting
    >


+ 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