chart problems

I have created a simple horizontal chart that shows the hours of attendance of clients at multiple program sites. The client names are listed down the left side . To the right is a program bar that measures the hours of attendance. I group these by center, and insert a page break after each group.    As long as there are 40 or fewer clients, everything works out. But some of my program centers have up to 100 clients. If I change the scale of the page to 8.5x14, this allows me to fit more of the large center roster on the page. But it then changes the scaling of the smaller centers. Is there any way to change the scale by group?

Edited by PBSELDEN - 12 Jul 2019 at 4:31am

Hi,

You can modify Y axis intervals but not based on group. If you have more than 100 clients in any program centers then try to create a conditional group to split them into small numbers and suppress group headers and footers to show them without changing page setup.

Thanks,
Sastry

Terrific solution. It does the trick.