ChartSize Property
Returns or sets the way a chart is scaled to fit on a page. Read/write XlObjectSize.
| XlObjectSize can be one of these XlObjectSize constants. |
| xlFitToPage. Print the chart as large as possible, while retaining the chart's height-to-width ratio as shown on the screen |
| xlFullPage. Print the chart to fit the page, adjusting the height-to-width ratio as necessary. |
| xlScreenSize. Print the chart the same size as it appears on the screen. |
expression.ChartSize
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
This property applies only to chart sheets (it cannot be used with embedded charts).
Example
This example scales the first chart in the active workbook to fit a full page.
ActiveWorkbook.Charts(1).PageSetup.ChartSize = xlFullPage