I am trying to use some VBA to print my charts to PDF and am having a hard
time. For now I’ve just selected the areas that the charts are in and used
the Selection.ExportAsFixedFileFormat Function I was wondering if you knew of
a way to print the chart to PDF by selecting only the chart? When I do this
it prints out the chart on an entire page rather than relative to its actual
size
Also, do you know of any ways to programmatically change the sizes of the
charts in a workbook. This was all possible in Excel 2003 using things like;
ActiveSheet.ChartObjects(“Chart 1”).Activate
and
With ActiveChart.PageSetup(margin1, margin2)
I don't necessarily need to use ChartObject to do this if there is another
way. All I am looking for is to be able to print charts to PDF and resize
them to my own specifications. Anyway of doing this will be greatly
appreciated
Thank you so much for anything you can do to help.
-Matt-
|