Excel Help

Total cost is what i need to sort, e.g. So that it displays the top 5 values in a range. Is there a forumla that does this?

Should i just the sort and filter tab and sort by the smallest to largest? And use data from top 5?

The reason i need to do this is to creat a pie chart of the top 5 greatest values, to be inclued in my pie chart.

Sorry if this isnt helpfull :(
 
The problem is you need 5 functions as you need to fill 5 cells and somehow make all the functions work together otherwise the will display the same solution.
 
Create a pie chart based on the top 5 cells, then whenever you paste new data in, sort and the chart will update automatically.
 
This is easy.

Set an area aside for the pie chart data.

In cell 1 put:

=LARGE(costdata,1)

[where 'costdata' is the area of data containing the costs you want to five the top X of]

Then cell 2 put:

=LARGE(costdata,2)

As many times as you want.

Then select the area where you have put the 'LARGE' functions and create a pie chart.
 
If total cost is in column A, then:

B1 =LARGE(A:A, 1) ---> Alternatively you could just use =MAX(A:A)
B2 =LARGE(A:A, 2)
B3 =LARGE(A:A, 3)
B4 =LARGE(A:A, 4)
B5 =LARGE(A:A, 5)

/edit, beaten - damn doing real work in between reading and posting.
 
You must log in or register to reply here.
Back
Top Bottom