You will often be asked to include a visual representation of numerical data in your business reports. The purpose of this activity is to sharpen your skills in determining what type of visual (chart, table, graph) is most suitable for a given set of numerical information. Use Excel to create visuals for the following. Be sure to label and title both of your visuals:

The companys allocation of employee benefits across all workgroups has fluctuated significantly in the last five years. Here are the percentages in each work group of those employees who are still enrolled in the benefits program, those who withdrew from the program, and those who are no longer with the company:

Customer Service Agents: 71% still enrolled, 27.9% withdrew, 1.1% no longer with the company

Fleet Agents: 62% still enrolled, 29.2% withdrew, 8.8% no longer with the company

Management: 53.6% still enrolled, 43% withdrew, 3.4% no longer with the company

Technicians: 68% still enrolled, 27.5% withdrew, 4.5% no longer with the company