Hi I am sure this has been asked before but I cannot find the answer to it.
I have a Bar chart and I have a pane up the Y axis to pane the data by Primary/Secondary Country and then by country. What I am finding is that I can have 3 countries in primary and 10 in secondary. However the primary part of the pane still takes up half the screen meaning there is a huge white gap below the last country before the first country in secondary starts.
How can I get this to space equally on country rather than on primary/secondary?
Neil, I'm afraid this is a limitation of the bar view. You can work around it by paning by a single formula field which merges the two fields such as: =[Primary/secondary]+" - "+[Country]