Ask Your Question

creating pie chart showing percentage

asked 2016-07-21 10:15:18 +0100

r144 gravatar image

hello group, I want to create an utterly simple pie chart that enables met to show the ratio of the amount in a cell compared to another cell (or fixed number).

So I have one cell containing a score, say 8, and another cell containing the norm score, say 12.

Now I want a pie chart that shows the score (8) being 66 % of the norm (12).

Can you guide me on this?

thanks in advance, Ruud

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-07-21 11:46:04 +0100

vhl gravatar image

You can create an additional cell holding rest=total - score. Then create a pie chart from the score and rest.

To insert the percentage, right click on the pie chart and select "Insert data label". Then right click the pie chart again, choose "Format data label", and tick "Show value as percentage"

edit flag offensive delete link more

answered 2016-07-21 16:30:54 +0100

r144 gravatar image

hi vhi, thanks for your suggestion. That was exactly the solution I came up with after asking this question. I was unsure if there was a possibility without the extra cell, but I think this is OK since it works.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-21 10:15:18 +0100

Seen: 4,564 times

Last updated: Jul 21 '16