Trying to illustrate a series of data into percentage

[keveitel]

I am trying to create a table and graph that illustrates the age of my equipment in a percentage value.

Specifically, I want to show:

1) That I have 29 Pieces of equipment that is between 30 and 40 years old as a percentage.
2) That I have 19 Pieces of Equipment that is between 20 and 29 Years old as a percentage.
3) That I have 20 Pieces of Equipment that is between 1 and 19 years old as a percentage.

[TABLE="width: 399"]
<tbody>[TR]
[TD="width: 230"]Nomenclature
[/TD]
[TD="width: 69"]Manuf Date
[/TD]
[TD="width: 112"]Equipment Age
[/TD]
[TD="width: 120"]Percentage
[/TD]
[/TR]
[TR]
[TD]Holding CAM Device
[/TD]
[TD]1978
[/TD]
[TD]40
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Machine, Grinding
[/TD]
[TD="bgcolor: transparent"]1986
[/TD]
[TD="bgcolor: transparent"]32
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Horizontal Honing Machine
[/TD]
[TD]1986
[/TD]
[TD]32
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Machine, Grinding
[/TD]
[TD="bgcolor: transparent"]1986
[/TD]
[TD="bgcolor: transparent"]32
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]750 Ton Hydraulic Press
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]N2 Trailer
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]N2 Trailer
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Oven, Dry Rod
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Lathe, Automatic
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lathe, Automatic
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Automatic Lathe
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Balancing Machine
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Balancing Machine
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Balancing Machine
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Hydraulic Forcing Press
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Electrode Oven
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Varnish Dip Tank
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lathe, Automatic
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Boring / Turning Machine
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Firing V Test Stand
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Dynamometer
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Dynamometer
[/TD]
[TD="bgcolor: transparent"]1987
[/TD]
[TD="bgcolor: transparent"]31
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Impregnation System
[/TD]
[TD]1987
[/TD]
[TD]31
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Hydraulic Test Stand
[/TD]
[TD="bgcolor: transparent"]1988
[/TD]
[TD="bgcolor: transparent"]30
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Bending Machine
[/TD]
[TD]1988
[/TD]
[TD]30
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Forcing Hydraulic Press
[/TD]
[TD="bgcolor: transparent"]1988
[/TD]
[TD="bgcolor: transparent"]30
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Boring / Turning Machine
[/TD]
[TD]1988
[/TD]
[TD]30
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]MSW Wheel Flange
[/TD]
[TD="bgcolor: transparent"]1988
[/TD]
[TD="bgcolor: transparent"]30
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Boring / Turning Machine
[/TD]
[TD]1988
[/TD]
[TD]30
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]48" Turret Lathe
[/TD]
[TD="bgcolor: transparent"]1989
[/TD]
[TD="bgcolor: transparent"]29
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Rotation System
[/TD]
[TD]1989
[/TD]
[TD]29
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Hydraulic Test Stand
[/TD]
[TD="bgcolor: transparent"]1990
[/TD]
[TD="bgcolor: transparent"]28
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Eddy Current Tube Tester
[/TD]
[TD]1990
[/TD]
[TD]28
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Eddy Current Tube Tester
[/TD]
[TD="bgcolor: transparent"]1990
[/TD]
[TD="bgcolor: transparent"]28
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]36" Turret Lathe
[/TD]
[TD]1990
[/TD]
[TD]28
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]54" Turret Lathe
[/TD]
[TD="bgcolor: transparent"]1990
[/TD]
[TD="bgcolor: transparent"]28
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Barge Assembly
[/TD]
[TD]1990
[/TD]
[TD]28
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Barge Assembly
[/TD]
[TD="bgcolor: transparent"]1990
[/TD]
[TD="bgcolor: transparent"]28
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Machine, Grinding
[/TD]
[TD]1991
[/TD]
[TD]27
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Dry Rod Oven
[/TD]
[TD="bgcolor: transparent"]1992
[/TD]
[TD="bgcolor: transparent"]26
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Voltage Regulator
[/TD]
[TD]1992
[/TD]
[TD]26
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Vets Stands
[/TD]
[TD="bgcolor: transparent"]1992
[/TD]
[TD="bgcolor: transparent"]26
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Thermal Dry Oven
[/TD]
[TD]1993
[/TD]
[TD]25
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Testing Machine
[/TD]
[TD="bgcolor: transparent"]1996
[/TD]
[TD="bgcolor: transparent"]22
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Tank Cleaning System (Vacuum)
[/TD]
[TD]1998
[/TD]
[TD]20
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Paint Booth
[/TD]
[TD="bgcolor: transparent"]1998
[/TD]
[TD="bgcolor: transparent"]20
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Machine, Boring, Jig (VF-4)
[/TD]
[TD]1998
[/TD]
[TD]20
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Tank Cleaning System (Vacuum)
[/TD]
[TD="bgcolor: transparent"]1999
[/TD]
[TD="bgcolor: transparent"]19
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Paint Booth
[/TD]
[TD]1999
[/TD]
[TD]19
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lathe (SL-40)
[/TD]
[TD="bgcolor: transparent"]2001
[/TD]
[TD="bgcolor: transparent"]17
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]EDM
[/TD]
[TD]2003
[/TD]
[TD]15
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Paint Dispensing System
[/TD]
[TD="bgcolor: transparent"]2003
[/TD]
[TD="bgcolor: transparent"]15
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Paint Dispensing System
[/TD]
[TD]2003
[/TD]
[TD]15
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Paint Dispensing System
[/TD]
[TD="bgcolor: transparent"]2004
[/TD]
[TD="bgcolor: transparent"]14
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Parts Washer
[/TD]
[TD]2005
[/TD]
[TD]13
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Parts Washer
[/TD]
[TD="bgcolor: transparent"]2005
[/TD]
[TD="bgcolor: transparent"]13
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Parts Washer
[/TD]
[TD]2005
[/TD]
[TD]13
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Dehumidifier / Chiller
[/TD]
[TD="bgcolor: transparent"]2006
[/TD]
[TD="bgcolor: transparent"]12
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Dehumidifier / Chiller
[/TD]
[TD]2006
[/TD]
[TD]12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Water Jet Cutting Machine
[/TD]
[TD="bgcolor: transparent"]2008
[/TD]
[TD="bgcolor: transparent"]10
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]CNC Punch Machine
[/TD]
[TD]2009
[/TD]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]CNC Vertical Melting Machine (VF-9)
[/TD]
[TD="bgcolor: transparent"]2010
[/TD]
[TD="bgcolor: transparent"]8
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Lathe
[/TD]
[TD]2011
[/TD]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Robotic Welding Machine
[/TD]
[TD="bgcolor: transparent"]2011
[/TD]
[TD="bgcolor: transparent"]7
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Testing Machine (ADTAS)
[/TD]
[TD]2012
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Testing Machine (ADTAS)
[/TD]
[TD="bgcolor: transparent"]2012
[/TD]
[TD="bgcolor: transparent"]6
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Water Jet Cutting Machine
[/TD]
[TD]2012
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[BGY23]

I am assuming you want to know the number of pieces of kit that fall into the various age categories. So in your sample you have 20 out of 67 pieces of kit that are in the 1-19 age group. This equates to 29.85%.

To do this, assuming your data starts at A5, tie row)....

Put this formula in D6 and copy down =IF(C6<20,"1-19",IF(C6>=30,"30-40","20-29")) Your age in years must be value not text.
Put your age groups in a table at say H5 to H7 now put this formula in I5
'=COUNTIF($D$6:$D$72,H5)/COUNTA($D$6:$D$72) This will return the percentage for the number of pieces in the age group

[TABLE="width: 136"]
<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1408;"> <col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 4384;"> <tbody>[TR]
[TD="width: 44, bgcolor: transparent"]Grp[/TD]
[TD="width: 137, bgcolor: transparent"]% of pieces[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1-19[/TD]
[TD="bgcolor: transparent, align: right"]29.85%[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]20-29[/TD]
[TD="bgcolor: transparent, align: right"]26.87%[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]30-40[/TD]
[TD="bgcolor: transparent, align: right"]43.28%[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]100.00%[/TD]
[/TR]
</tbody>[/TABLE]

 

[BarryL]

if you're looking for it in the column beside the data you could try the below (taking your data being in columns A-C, put this in D2)

=CHOOSE(IF(C2>=30,1,IF(C2>=20,2,3)),COUNTIF(C:C,">="&30),COUNTIFS(C:C,">="&20,C:C,"<"&30),COUNTIF(C:C,"<"&20))/COUNTA($C$2:$C$68)