ChartSize Property

Microsoft Excel Visual Basic

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