up vote 0 down vote favorite
share [g+] share [fb]

I need to distribute correctly a little data in an excel graph.

I have the total I've earned last year which should represent the 100% of the cake.

Then I have my insurance expenses and I want to understand, graphically, how much of my total income went away to pay insurance...

I know that a basic proportion like:

total expenses : total insurance costs = 100 : x

do the correct math but I can't find a way to display this in a cake graph...

Any hints?

link|improve this question
98% accept rate
1  
... you mean a "pie chart" ? – Sirex Jan 14 '11 at 13:07
feedback

1 Answer

up vote 0 down vote accepted

In order to be able to make a pie chart correctly, you need to list the percentage for each item, and the sum of all these percentages must be equal to 1.

For example,

Total insurance cost: 0.2
Expense A: 0.4
Expense B: 0.3
Expense C: 0.1
link|improve this answer
You don't need to do the scaling yourself, the pie chart will do it for you – James Jan 14 '11 at 13:17
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.