The report I am working on contains a horizontal bar chart in the report footer. At this time, I can only get the chart to display on a single page. My problem is that there are too many bars/data to fit well on a single page, the axis label displays in a font too large and the values overlap, and therefore do not correspond with their associated bar.
Can you help me with a method to either get the chart to grow to additional pages as needed to display the axis labels and bars better, or how to display the axis label in a font small enough so it does not overlap with the labels above and below?
The font size is already set to the smallest available size of 4 in the 'format axis label' options. The section containing the chart has 'keep together' deselected in the options. The format chart editor has 'keep object together' deselected.
Is there a custom 'page setup' that would allow the report footer to be vertically longer and thus allow for more horizontal bars to display?
I will appreciate any ideas.