Hi all,

Long time lurker here, this site has been a hugely valuable resource for me and I appreciate it, thanks!

I'm stumped by a problem I'm having with a chart generated via a macro. I'm able to generate it from a Pivot Cache and place it on the worksheet where my table is located. I just can't seem to figure out how to automatically size the chart between the last row of the table and the page's bottom margin. Is there a way to do this? Keep in mind that I can't know how many rows will be in the table, and when printing I have the scaling set to "Print All Columns".

Is there a constant in excel to refer to the bottom page margin? Could I use that to calculate the graph height?

I also can't seem to figure out how to center the graph between the left and right margins of the page, any suggestions?

Thanks in advance!