Pie Chart Problem

[sfar007]

Hi,

My data consists of 1896 responses. I divided the data into boys (944) & girls (952). These are further divided into 4 rows (98, 121, 521 & 204) as shown in the boys example below. 944 are the total boys reponses and the other 2 are the total percentages:


98 5% 10%
521 27% 55%
121 6% 13%
204 11% 22%
944 50% 100%

The first column of percentages is worked out on the total number of responses (1896), while the 2nd column is worked out on the boys responses (944). My problem arises when i try to create a pie chart with the 1st column of percentages, which i want it to reflect it on the total number of responses. I create the pie chart by highlighting the series up to the 1st column, excluding the last row - but the output is given on the 2nd column of percentages. (The 2nd column of percentages is not shown in my data set - it is shown here for explanatory purposes).

Is there some other way of going around this problem?

Thanks for any help

BR
Stefan