How to generate graph

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:



ParticipantSexAgeV1V2V3V4VTH1H2H3H4HTI1I2I3I4ITT1T2T3T4TTS1S2S3S4ST
1124354183132921429443516431513
21142541624341322419352414543416
31232441541521211327355518544417
41243521644331411417424515533516
511135414345315224311224412233412
61111521044541731419243413443516

<tbody>
</tbody>


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.
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

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
Top