Manipulating chart height & Pagebreak to accomodate

Hi Guys

In the attached file I am trying to achieve the following:
- Each charts height to accommodate the number of legend entries
- Same row space between each chart

Have tried to achieve above with red snippets of code...

- Set Page breaks so that the pdf created does not chop off charts...

Any advice to assist in achieving my goal...

Please Login or Register  to view this content.

Alrighty then...

I managed to solve the chart distance by doing the following...
Changing this snippet of code...

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Now just to solve the page breaks that ensures that charts do not get cut off...
Any ideas...

Come on guys...Any ideas!!!!

The attached upload has the charts placed on the sheet...As it would not be possible to get the page break rows prior to placing the charts - storing them into array to make use of later...The only other way I can think of is to move the page breaks after the charts have been placed...

This works, however, it is far to slow...Must be a simpler method!!!

Please Login or Register  to view this content.

Alright y then guys....Thanks so much for all your valuable input on this one lol....

Storing the PB rows into an array first and then looping improves the speed down to 4 seconds or so...

Please Login or Register  to view this content.