Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
1  
... you mean a "pie chart" ? –  Sirex Jan 14 '11 at 13:07

1 Answer 1

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
share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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