Hi
I have a pivot table that produces a pivot chart but depending on which department is selected the number of staff can make the chart unreadable.
Is there away of saying have only 6 people per chart based on the selection of from the pivot table page?
Thanks for any help with this
N
I have a pivot table that produces a pivot chart but depending on which department is selected the number of staff can make the chart unreadable.
Is there away of saying have only 6 people per chart based on the selection of from the pivot table page?
Thanks for any help with this
N