PDA

View Full Version : Assistance Request: Pivot Table and Charts



emyclarke91
2016-10-09, 06:09 AM
Hi everyone,


I am new to excel. I would like to ask for help in solving this problem about pivot table and charts. (Please see attached excel worksheet..) This was a test during my application 2 months ago. Until now I am not able to solve this problem.

Appreciate your help. Thanks! :-)

emyclarke91
2016-10-09, 03:40 PM
This is it!











1. From the Raw Data tab, create a Pivot table and Charts in another sheet with the following criteria









a. Age Bracket
Generation
Birth Starting
Birth Ending




Baby Boomer
1945
1964




Generation X
1963
1981




Generation Y
1982
1995




Generation Z
1996
2015










b. Tenureship
Tenureship






6 to 8 yrs






4 to 6 yrs






2 to 4 yrs






1 to 2 yrs






Less than a year












c. Gender






d. Location






e. Position/Level breakdown







Can anyone help me?

Thanks! :)

emyclarke91
2016-10-10, 05:11 AM
Hi guys,

Update to my post this is the complete excel with raw data. (Please see attached excel.)

Thanks! :)

Ed Kelly
2017-05-06, 01:45 PM
A little late to the Party is a bit of a stretch, you may have long solved this puppy, however just in case here is a quick and dirty as I noticed that you did not get a response.

Knock 'em dead sailor