Afternoon
Can someone help me out with some chart information.
I gather statistics on tasks undertaken by my despatch team and create charts for each task per day.
I need to find a quicker method of returning the information on the results in a chart.
I know I can move the selection field for the amount of staff working.
I would like this to be automated by means of the data not selection staff that have not carried out that task. i.e there are "0's" making the charts smaller.
There name has to remain as they would have been carrying out another task, but does not have to show for the chart in question.
I use one tab per person and the collate the data so that it compiles.
Hope this makes sense and someone can help me out.
I have given an example of my data.
Thanks in advance.
Bookmarks