Hyperlinkage of one graph with another graph or Drill down graph

  • Thread starter Sanjay Kumar Singh
  • Start date
S

Sanjay Kumar Singh

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/com...29f4ad8f2f&dg=microsoft.public.excel.charting
 
T

Tushar Mehta

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/newsgroups/dynamic_charts/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

8?B?U2FuamF5IEt1bWFyIFNpbmdo?= <Sanjay Kumar
(e-mail address removed)> says...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top