Conditionally expand chart onto multiple pages

[duthiedon]

Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another. My first thought is I don't think MS access can do this, but I'm wondering if there are solutions.:banghead:

 

[JHB]

How about splitting the data up in two parts, and put each part in it own chart, then put the second chart on the next page?

 

[duthiedon]

Thank you, I thought of that myself, the problem is that it's a generic chart, so sometimes it's not necessary to expand onto 2 pages. It's based on each project, and the more complex project will require 2 pages and some projects it's not even a full chart.

 

[JHB]

Then determine the number of bars and then make the second chart visible if it require 2 pages.

 

[duthiedon]

Thanks again! I was hoping that there was an easier way. I also solved a related problem where there seemed to be a maximum size to the chart, but solved that issue by changing the setting to zoom instead of stretch. Thanks for your help.