Pie Chart % issue and Radio buttons
I have a report that sales by City. There are 200 cities and sales % per city is shown in desceding order. As 200 cities I had difficulty to show In pie chart, I showed top 30 cities which account for nearly 70%. The issue is Pie chart calculates one more % based on values in selection and shows two different %s. one from Excel and another one that is calculated based on top 30 cities and thsi si not accepatble. How can i get rid of this new % that is aclculated based on values in selection?
2. I want to give option to users to select either top 30 or all. How can I give should I use radio buttons? Any example xlf file?
Plese help me
BR, Nanda Kishore
The option you can try out is
Appearance -> Text -> Data Labels (specify only 'Value' for 'Label Contains')
As we don't have control on how Mouse-Over values should be displayed.
Please Uncheck 'Mouse-Over Values'
This will not show new %.
For 2nd question, Pie chart is not suitable when data points are more..
So, you can select a Column Chart and enable Range Slider... such that user can focus on required data only by narrowing the
range in slider.