Hi,

I am using a PivotChart to get a distribution line of Personal Development Ratings (1 to 5), to show for each manager, I have 10 managers in total. I do a PivotTable, show values as percentages, I get 10 lines (one for each manager). However, there is just too much going on, too many lines and colours, so you can't see which manager is following a binomial curve of distribution. So I click on the filters and choose one manager and then his line goes flat, whereas previously it was pretty much a binomial curve (take or give a little).
How can I fix this? Many thanks, Leila