using calc, created pie chart with a column of labels and a column of numerical values, want the chart to show the percent of each category relative to total amount
Hello,
Select chart so points show (double or triple left click):
Right mouse click in any section and select Insert Data labels. Values are inserted:
Right mouse click again and select Format data labels...
In dialog on Data Labels tab select you choices under Text Attributes:
How to show 2 decimals for the percentage? When I unselect “Source format” in “Number Format for Percentage Value” and select “Percent” with “Decimal places” set to 2, nothing changes. On the contrary, when I go back to that “Number Format and Percentage Value” page, the “Source format” tick box is activated again…
How can I show 2 decimals in my pie chart when using percentage?
Related question /question/284252/.
@Ratslinger, Maybe these comments can be deleted. You can delete/edit this my comment once read. Thanks.
No, will let these sit. @GeertVc tried to hijack the question using a comment. So I posted an example. Instead of responding, and without any mention here, it was posted & answered as a new question.
Besides, maybe others will be thankful for the information.
- Double click your diagram (edit mode
→ black handles) - Right hand click into pie → Format Data Labels
- Data Labels :: Text attributes → [x] Show value as percentage
PS: Please do not ask your question as a wiki - thank you.