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.
This property applies only to chart sheets (it cannot be used with embedded charts).
This example scales the first chart in the active workbook to fit a full page.
ActiveWorkbook.Charts(1).PageSetup.ChartSize = xlFullPage