ChartSize Property

         Example         Applies To

Returns or sets the way a chart is scaled to fit on a page. Read/write Long.

Can be one of the following XlObjectSize constants.

Constant 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).