If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pie chart grouping
hello
I have some data (exam marks) as follows 64.4 49.3 64.6 76.9 50.9 69.7 73.9 62.6 82.4 68.3 49.4 56.9 59.3 68.6 55.3 74.1 65.9 68.2 67.9 71.5 67.7 64.5 66.7 73.1 41.8 53.3 I want to produce a pie chart that shows marks: 1st = 70% and above, 2:1 = 60 - 69% 2:2 = 50 - 59% 3rd = 40 - 49% Is there an easy way to do this. shane |
#2
|
|||
|
|||
pie chart grouping
YOu can make a lookup table of the groups:
0 3rd 50 2:2 60 2:1 70 1st With your table of marks starting in cell A1, enter the following formula in cell B1: =VLOOKUP(A1,$D$1:$E$4,2) where D1:E4 is the lookup table. Copy the formula down to the last row of data. To count the marks in each group, enter this formula in cell F1: =COUNTIF($B$1:$B$26,E1) and copy down to F4 Select cells E1:F4, and use the Chart Wizard to create a pie chart. wrote: hello I have some data (exam marks) as follows 64.4 49.3 64.6 76.9 50.9 69.7 73.9 62.6 82.4 68.3 49.4 56.9 59.3 68.6 55.3 74.1 65.9 68.2 67.9 71.5 67.7 64.5 66.7 73.1 41.8 53.3 I want to produce a pie chart that shows marks: 1st = 70% and above, 2:1 = 60 - 69% 2:2 = 50 - 59% 3rd = 40 - 49% Is there an easy way to do this. shane -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|