Hi there,
This is my first post on this forum, so bare with me.
I am trying to chart the performance of telesales personnel at my workplace.
I would like to use a line chart to 'chart' their performance over a period of time (so Y-axis = Date).
The Variables are:
Total Call Time
Total Talk Time
I would like the option to expand the chart as time progresses, so I can continue to update the chart with staffs performance, and get a clear picture of their avg. performance over time.
Please find attached the data sheet.
Any help on this would be greatly appreciated.
Many thanks
Alex
I would suggest that a Pivot Chart is the way you might go.
If you specify your names as legend fields/column labels, the dates as row labels and either of the numbers as values you will get a chart which makes it easy to compare performance to each other and invidually over time.
See Excel Help for more details.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks