Excel 2007 : excel survey data

**martin_84** · 04-09-2012, 05:48 AM

Hi I'm currently analyzing some data from a survey and I experience some trouble when I’m trying to make this into a pie chart the survey had 3 options but when inserting this data into a pie chart I get a pie chart that counts from 1-10.0 How do I change the vectors? Thank you in advance

**mrice** · 04-09-2012, 05:54 AM

Can you post some data as an attachment?

**martin_84** · 04-09-2012, 06:00 AM

sure see sheet 3 stats prosjekt.xlsx

**mrice** · 04-09-2012, 06:22 AM

I think that you need to be using the countif, sumf and averageif functions to agregate your data prior to attempting to plot it using a pie chart.

Have a look at the definition and examples for these in Excel help.

Please post again if this doesn't make sense.