How to force stacked bar to show 5 and group the remaining in Others

[#1]

I have a stacked bar chart and the second dimesion we're using has many values (e.g. Salesperson).  We'd like to show only 6 values on the chart, the top 5 plus all others grouped in "Other" - similar to the pie chart where you can choose how many slices.  Thoughts?

Thanks,

Kevin

[erichshiino]

Hi,

Go to the char properties -> Presentation tab -> Dimension limitation box (on the top right) -> Select the second dimension -> Mark 'Max Visible number' and set it to 5

In the middle of the same widow  mark 'Show Others (Label) ' and write a name to the group of Others

Hope this helps,

Erich