Assistance Request: Pivot Table and Charts

E

emyclarke91

New member
Joined
Oct 9, 2016
Messages
3
Reaction score
0
Points
0
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! :)
 

Attachments

  • Excel Pivot Table.xlsm
    10.5 KB · Views: 12
This is it!


1. From the Raw Data tab, create a Pivot table and Charts in another sheet with the following criteria
a. Age BracketGenerationBirth StartingBirth Ending
Baby Boomer19451964
Generation X19631981
Generation Y19821995
Generation Z19962015
b. TenureshipTenureship
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! :)
 

Attachments

  • screenshot.JPG
    screenshot.JPG
    39.3 KB · Views: 15
Hi guys,

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

Thanks! :)
 

Attachments

  • Excel Data.xlsm
    32 KB · Views: 12
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
 

Attachments

  • Excel Data.xlsm
    126.8 KB · Views: 12
You must log in or register to reply here.
Back
Top