Ask Your Question
0

creating pie chart showing percentage

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

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
0

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

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
0

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

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.

Ruud

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 4,415 times

Last updated: Jul 21 '16