WidthRatio Property

Microsoft Office Web Components Object Model

WidthRatio Property

       

Returns or sets the width ratio for the specified chart in relation to the other charts in the chart workspace. The default value is 100. Read/write Long.

expression.WidthRatio

expression   Required. An expression that returns a ChChart object.

Remarks

For this property to have any effect, you must have more than one chart in the chart workspace. When more than one chart is displayed, the charts are displayed in a grid (for more information, see the Help topics for the ChartLayout and ChartWrapCount properties). Initially, the HeightRatio and WidthRatio properties are set to 100 for all charts in the grid, and all charts are the same size.

To change the width of charts in the grid, adjust the WidthRatio property settings. For example, if each chart is displayed in three columns all charts have an initial WidthRatio setting of 100. If you want column 3 to be only half the available column width, set its WidthRatio setting to 200; the remaining half of the chart width will be divided between columns 1 and 2. Because the width specified by the WidthRatio property is relative, you can set this property for the three columns to 1,1,2; 100,100,200; or 20,20,40. all of which have the same effect.

If the chart workspace contains charts displayed in more than one column, the largest WidthRatio setting in each column is used to set the relative width for the entire column.

This property is useful for creating price and volume stock charts in which the volume chart is half the size of the price chart.