How to generate graph

B

baluch

New Member
Joined
Apr 12, 2013
Messages
1
Hello everyone,
I am really knew to excel and do not have much experience. I was really hoping some people can help me out. I have tried to do this myself but can't seem to figure it out.
Basically, I distributed a survey for Parking enforcement officers and Workplace Violence and Harassment.

I want to generate a graph one for low harassment and high harassment (x-axis) and then stress is the y axis
second graph low training and high training (x-axis) and then stress is the y axis.

I would be really grateful in the help, and would certainly compensate somehow.
thanks.
My results are the following.

V stands for the Violence questions
VT is the total points for each participant in that section

H is harassment questions

I is interaction

T is training

S is stress

my survey is the following:



[TABLE="width: 1800"]
<tbody>[TR]
[TD]Participant[/TD]
[TD]Sex[/TD]
[TD]Age[/TD]
[TD]V1[/TD]
[TD]V2[/TD]
[TD]V3[/TD]
[TD]V4[/TD]
[TD]VT[/TD]
[TD]H1[/TD]
[TD]H2[/TD]
[TD]H3[/TD]
[TD]H4[/TD]
[TD]HT[/TD]
[TD]I1[/TD]
[TD]I2[/TD]
[TD]I3[/TD]
[TD]I4[/TD]
[TD]IT[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]TT[/TD]
[TD]S1[/TD]
[TD]S2[/TD]
[TD]S3[/TD]
[TD]S4[/TD]
[TD]ST[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]


Please refer to the scales in each section to rate your response to the questions.
1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree

1.I do not feel safe at work at all times 1 2 3 4 5
2.My workplace does not make me feel secure when I am at work 1 2 3 4 5
3.I understand that I may encounter violent individuals in my workplace 1 2 3 4 5
4.I know someone that has encountered a violent individual 1 2 3 4 5


***************1= never
2= rarely
3= sometimes
4 = not always
5 = always

5. I am harassed at least once a week during my shift 1 2 3 4 5
6. Harassment in the workplace affects my personal life 1 2 3 4 5
7. I cannot prevent harassment while at work 1 2 3 4 5
8. Harassment has affected my behaviour at home 1 2 3 4 5




How often has a stranger interacted with you while at work?

1 = daily
2 = weekly
3 = monthly
4 = once
5= never

9. Smile at you when passing by 1 2 3 4 5
10. Said Hello 1 2 3 4 5
11. Swore at you 1 2 3 4 5
12. Made a comment about you while passing by 1 2 3 4 5







1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree


13. The violence and harassment training that I have received is not helpful 1 2 3 4 5
14. I feel like my workplace is not supportive and unresponsive 1 2 3 4 5
15. Procedures regarding violence are in place and easy to follow 1 2 3 4 5
16. I have been adequately trained in dealing with harassment 1 2 3 4 5

**********************************************

1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly agree

17. Workplace stress contributes to my behaviour at home 1 2 3 4 5
18. I have trouble sleeping at night 1 2 3 4 5
19. I think about my job during my family time 1 2 3 4 5
20. My job is stressful 1 2 3 4 5




21. Sex (Please circle) Male Female
22. Age (Please circle) 20 – 30 31 – 40 41 – 50 over 50




Thank you for your participation.
 
You must log in or register to reply here.

Similar threads

D
  • Question Question
Generate unique subsets with even distribution.
Replies
6
Views
174
Kaper
Kaper
jlhoover3
  • Solved
Excel Rank Function with 18 Decimal Places
Replies
3
Views
153
Peter_SSs
Peter_SSs
H
  • Question Question
Transposing Data - Evaluating formula to an array error.
Replies
1
Views
97
Skyybot
Skyybot
R
  • Question Question
VBA Generate email with multiple data in body.
Replies
2
Views
437
Logit
Logit
C
  • Solved
I need a formula to a) find the first numeral in a text string b) remove that numeral and all the characters after that numeral
Replies
3
Views
164
Peter_SSs
Peter_SSs

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top