Hi Gurus,
I want to ask if it is possible to drill (up/down/through) the Pie chart by clicking the description info please?
I can click the "pie" graphic to do this, but I want to do that by clicking the number and words (like 20% or "productA")
If it is not possible I will not continue searching .
See attach about the question
Thanks
I don't think it can be done.
Having said that - why are you using a pie chart at all? I mean, if you write down your categories' names, their values and percent of total, why do you need the drawing in the middle?
Take a look at this: https://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf
If you don't want to read the whole thing read just page three and four. Might it be that a table will serve you better?
Taking Nimrod's point (purely because he beat me to posting my favourite anti-pie chart link), you could present your data more like the attached. You could then control the drill throughs from each of the data points, so that user could click on the Revenue, the category, the percentage or the bar in the chart to get to the same data.
Thanks so much