Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I don't think is possible, you can try this workaround
- 3 chart with a button to reproduce the fast change; in the button you set a variable to make visible first or second or third chart (layout tab --> show--> conditional)
- or single object container with 3 chart (similar to the previous one)
I have the same problem. There are no standard options to set limits on chart type?