Your data needs to look like:
Category A 25
Category B 75
in a 2 x 2 grid. You don't need to convert to percentages, you can just keep
the sums:
Category A 18
Category B 54
and if you want, the data labels can display the percentages. Notice that
the total in W41 does not appear in the grid. Select the 2 x 2 grid and run
the chart wizard to make the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Corey" wrote in message
...
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