WidthUsePU Property

The WidthUsePU property returns/sets if the worksheet bar width values are to be treated as percentages or page units when WidthType is set to grfWidthColumn. When True, page units are used. When False, percentages are used. Returns a Boolean.

Syntax

object.WidthUsePU

object.WidthUsePU = WidthUsePU

 

Parameter Type Description
WidthUsePU Boolean required; True = page units, False = percentages

 

Example 1

This example shows how to set the width in page units for a bar chart.

Bar1.WidthType = grfWidthColumn

Bar1.WidthUsePU = True

Example 2

This example shows how to set the width in percentages for a floating bar chart.

Floating1.WidthType = grfWidthColumn

Floating1.WidthUsePU = False

 

Used by: AutoBarChart object, AutoFloatingBarChart object