Hi,
I am trying to creat a graph that is nested in a parent child relationship.
For example I have some data the lists production scrap and a value by month. There is also additional area that breaks the scrap value down by reason code, and these reason codes are then broken down by production area.
Is there a away of setting up two graphs as follows:
The idea being that when a given reason code is selected, the linked graph automatically produces the related production area graph.
Any general pointers would be great.
Thank
M
I am trying to creat a graph that is nested in a parent child relationship.
For example I have some data the lists production scrap and a value by month. There is also additional area that breaks the scrap value down by reason code, and these reason codes are then broken down by production area.
Is there a away of setting up two graphs as follows:
- A parent graph for each reason code i.e. Reason Code vs Month
- A child graph that gives further analysis of a selected reason code by production area i.e Production area vs Month
- Discrete data, so would be a bar chart with a trend line.
The idea being that when a given reason code is selected, the linked graph automatically produces the related production area graph.
Any general pointers would be great.
Thank
M