Applies To
PageSetup Object.
Description
Returns or sets the method used when scaling a chart to fit on a page, as shown in the following table. Read-write.
|
Value |
Meaning |
|
xlScreenSize |
Print the chart the same size as it appears on the screen. |
|
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. |
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