Your first day of interning in the Horizons Medical Center has you working in the HR department. The department supervisor has asked that you combine information from a Microsoft Office survey distributed to a few hospital departments. The supervisor believes that the information will be better explained using charts.

Option 2: Alternative Assignment

Your first day of interning in the Horizons Medical Center has you working in the HR department. The department supervisor has asked that you combine information from a Microsoft Office survey distributed to a few hospital departments. The supervisor believes that the information will be better explained using charts.

Create a spreadsheet from the data below and generate two charts to visually represent the data. The chart types should be:

  • Pie Chart in 3D – Depicting only the Excel users

  • 3D Clustered Column Chart – Comparing all software used per department

Cardiology Dermatology Neurology Human Resources Purchasing
Excel 35 12 5 7 35
Word 15 35 17 15 10
PowerPoint 17 5 12 5 3
Access® 17 15 8 10 15
Publisher® 1 15 22 15 25