I am trying to do a column chart with the training that people attended
below. I would like to find which people took "AT LEAST ONE CLass", AT Least
TWO classes, and AT LEAST 3 Classes and that's it. I would like to put it by
Department. I have done a pivot table and did IF function to create the "the
AT Least One Class, etc. but now I want to chart the info - not sure how to
do the "count "- It seems like it should be easier than this.


Any ideas or quick ways to summarize on charts TRaining taken info????

Thanks,
BArb

Department First Last Location Learning Method Hours SessionStatus Date
CostPerEE EEStatus
Finance Leonardo Rossi Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735
Active
Finance Michele L. Sucich Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735
Active
Finance Rosella M. Yontz Bannockburn BBA ILT/Vendor 0 Cancelled 1/23/07 $0
Active
Food Service Felicia
L. Pierce Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735 Active
Food
Service Catherine Terry Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735
Active
Human Resources Laura
A. Birk Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735 Active
Human Resources Wayne
M. Bosch Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735 Active
Human Resources Margaret
R. Fillman Bannockburn BBA ILT/Vendor 0 Cancelled 1/23/07 $0 Active
Information
Systems Lee Trentlage Bannockburn BBA ILT/Vendor 0 Cancelled 1/23/07 $0
Active
Logistics Patricia
L. Clouthier Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735 Active
Logistics Deborah Robinson Bannockburn BBA ILT/Vendor 0 Cancelled 1/23/07 $0
Active
Logistics Kellan Walsh Bannockburn BBA ILT/Vendor 8 Attended 1/23/07 $735
Active