Hi,
I have a pivot table report that includes a series of ratings out of 10.
These ratings are listed against the staff member for each job they do.
Ie Bob Job-1 9.6, Bob Job-2 9.4, Bob Job-3 9.2 and so on.
Currently i have the chart showing all the ratings by staff member which is in a simple column chart.
Is it possible to include an average of the ratings on that same chart preferably as a line or as something to show its the average?
I have a pivot table report that includes a series of ratings out of 10.
These ratings are listed against the staff member for each job they do.
Ie Bob Job-1 9.6, Bob Job-2 9.4, Bob Job-3 9.2 and so on.
Currently i have the chart showing all the ratings by staff member which is in a simple column chart.
Is it possible to include an average of the ratings on that same chart preferably as a line or as something to show its the average?
