Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Chart Size with Excel 2007
I am trying to use some VBA to print my charts to PDF and am having a hard
time. For now Ive 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- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define the size of an Excel Chart (Office 2007)?? | Charts and Charting in Excel | |||
2007 Excel/Powerpoint - Chart size when linking | Excel Discussion (Misc queries) | |||
How do I size a chart with the window in excel 2007 | Charts and Charting in Excel | |||
Stop URLs from changing font size - Excel 2007 | Excel Discussion (Misc queries) | |||
Changing Excel Chart Size | Excel Programming |