I have a department of 10 and track performance data on them. I would like to create an individual chart for each of them that graphically displays all their data on one excel page. I'm stuck in building each chart. Here's what I want:
1. How do I build the chart to filter data for a specific individual?
2. I want the chart to display (on the X axis) the type of work and (on the Y axis) the number of data elements planned and the number executed.
The Excel file contains the following:
Data Type Planned Data Collection Completed Data Individual (initials)
Dosimetry 5 3 AM
Air Sample 12 5 AM
Dosimetry 2 0 DR
Air Sample 5 1 AM
How would I build the chart to show AM's total Dosimetry Planned and Completed and Air Samples Planned and Completed (as vertical bars)?
I've searched the forum and found similar items but nothing that allows me to complete this chart.
Thanks.
Bookmarks