Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question