ChartSize Property

Applies To

PageSetup object.

Description

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

Example

This example scales the first chart in the active workbook to fit a full page.

ActiveWorkbook.Charts(1).PageSetup.ChartSize = xlFullPage