I am trying to set up a chart from data in an excel spreadsheet, but am
having difficulty thus far.

I have a cell values as follows:

w41 = total hrs
x3-x20 = category A
y3-y20 = category B


I want to have the Pie Chart to show what (%) of w41 is category A
and
what (%) is category B of w41.

Eg say :
w41 = 100

cat A(sum) = 25
cat B(sum) = 75


I cannot get these segments(slices) to be separate, but i keep getting W41
value = 100% and the other segments do not display.
Can anyone assist me with this setup, i am sure it is easy yet as i do not
work with charts i cannot get it set right.


Regards

Corey