Is there a way to automatically size a chart based on data?

[Morgan]

Specifically, I have a Gantt chart I want to display. The number of rows of data could be anything from 1-50; for just one row I want a small height on the chart so it doesn't look bulky, while with many rows I want a larger height so that they can be seen clearly. Is there a way to re-size a Gantt chart based on how many rows of data we have? Width should not change, and it can be within a min/max height. In a pinch, just setting it to min or max height would be workable.

[HighAley]

Specifically, I have a Gantt chart I want to display. The number of rows of data could be anything from 1-50; for just one row I want a small height on the chart so it doesn't look bulky, while with many rows I want a larger height so that they can be seen clearly. Is there a way to re-size a Gantt chart based on how many rows of data we have? Width should not change, and it can be within a min/max height. In a pinch, just setting it to min or max height would be workable.

It's possible to change chart's size in the Before Print event.
Please, look at the attached report template.

GanttGroup(1).mrt

(26.67 KiB) Downloaded 198 times

Thank you.