How to create a progress chart tracking 3 different data sets for multiple employees
Posted on 2014-01-16
I think I need a bar chart to use as a dashboard. I tried conditional progress bars but the formatting is a nightmare because I can't use relative references and have to format each cell individually. Adding and removing rows is too time consuming.
The data is a yearly tracking by month for employee's goal, booked, and collected amounts.
E1, goal, booked, collected
E2, goal, booked, collected
Any ideas how this could be set up so that mangement can easily add data for goal, booked and collected and I can easily modify number and names of employees?
I think a stacked bar chart might be a nice way to display all 3 data amounts for each employee. But I'm open to any suggestions. I'm using Excel 2010.
Thanks in advance for your help!