Hi,
I need a chart that drills down into another chart. I have grouped based on state, then on county, then on city. When I double-click on the state in my pie chart, I want it to take me to another pie chart based on the counties in that state. Instead, double-clicking only takes me to the table data for that state.
The three groups have been created, and there is summary information for them in the group footers. I wonder if I'm doing something wrong in the Chart Expert. The layout is set to group, and the "On Change of" is set to State. What do I need to do to get a chart that drills down into another chart?
Thank you.