Pie chart help excel 2007

[adocholiday]

Hi all,

Great forum! Really need some help with a pie chart. I am analysing data from a survey I carried out on where last years graduates are now.

I am trying to analyse a number of questions together as so:

1. What is your current employment situation? (select one)
-employed
-unemployed
-self employed

2. Are you currently undertaking any unpaid work? (internship etc)
-yes
-no

3. Are you currently travelling?
-yes
-no

4. Are you in further education?
-yes
-no

What I want to do is create a large pie chart showing only employed, self employed and unemployed and have other pie charts linked to each section showing the proportion of people in each category who are doing unpaid work, travelling and/or in further education.

Hope I'm making sense..... I can't seem to set up a pivot table or even manually key in the info to give me the chart I want. Really would appreciate some help on this!

 

[VoG]

Look here http://peltiertech.com/Excel/Charts/ChartIndex.html

and here http://www.andypope.info/charts.htm

 

[adocholiday]

Thanks for that I found the pie chart solution here:

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=471

Now I have a new problem. I'm using a pivot table and I have my rows as employed, self employed and unemployed, my columns are further education, unpaid work and travelling. My count is the employment situation.

What's happening is that it's grouping all the answers. i.e. it's telling me the employed people that are currently doing some unpaid work however it's also telling me the amount of people in this group that are also travelling.... it's too much information. I don't know how else to explain it lol! It should be very simple but it's anything but!