Dimension limits/Conditional dimensions based on chart type
I have a fast type change chart containing bar, pie and a scatter charts. All those charts need to have have the same dimension (which is a cyclic group). The problem I am facing is that I want to limit the dimension to top 5 with others in pie chart, top 10 in scatter and no limit in bar. Is there some setting to limit the same dimension based on the chart type?
The other way that I think to do this is to make 3 copies of that group by different names and use that each dimension based on the chart type. But how do I choose specific dimension based on the chart type? I really don't wanna use macros. Any kind of help will be appreciated.