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!
Bookmarks