Excel problem

dominatrix1 · 3 Dec 2008 at 14:43

Basically i have two sets of data 18 users. male and female and for each user how long they have bene using the internet . I want to somehow display differences if any between their useage and display it in a graph. DOes anyone know how i can do this?

Morba · 3 Dec 2008 at 14:45

do you mean difference between the men and the women?

total the usage of the 2, then create a bar chart. simple tbh

dominatrix1 · 3 Dec 2008 at 14:48

not really sure just the best way to display that data

Mull3t · 3 Dec 2008 at 15:00

Sperate the girls from the boys in your excel sheet, Total up the 'total' for each.

Create a graph, say a bar chart, change the colours, pink for girls, blue for boys.

And Voila, that should give you a side by side bar chart showing the difference.

Morba · 3 Dec 2008 at 15:08

dominatrix1 said:
not really sure just the best way to display that data

bar chart. its the only way. unless you want to display each as a percentage of total usage.

do you want boy/girl or all individual stats to show?

Col_M · 3 Dec 2008 at 15:15

Tried a pivot table?

Just select the data then in the wizard drag in the fields you want and the way you want it shown.

suarve · 3 Dec 2008 at 15:28

Col_M said:
Tried a pivot table?

Just select the data then in the wizard drag in the fields you want and the way you want it shown.

I'd go with a pivot table initially too. YOu can then mess about until you get the exact data you want and then make a graph out of the sorted data.

Namsnik · 3 Dec 2008 at 22:23

If you want a more sophisticated approach then try a box and whisker - though you haven't got much data. Google excel box and whisker or just look at these examples/explanations.

http://www.duncanwil.co.uk/boxplot.html
http://en.wikipedia.org/wiki/Box_plot