Sorry if this is a bit of a silly question but I have a stacked column chart that displays products by the summed value of it's component parts. I would like to show a Donut chart that displays the component parts of the selected product in the stacked column chart.
When I try to do that, all I get is a donut chart that displays all the products in the chart and then if you choose a value in the column chart it gets shown as a tiny slice in the donut rather than the donut showing just the selected column and its component parts.
Does that make sense?
Thanks for any help you can give!