WidthCol Property

The WidthCol property returns/sets the worksheet column from which the bar width values are to be taken. Ignored unless WidthType is set to grfWidthColumn. Returns a Long.

Syntax

object.WidthCol

object.WidthCol = WidthCol

 

Parameter Type Description
WidthCol Long required

 

Example 1

This example shows how to set the width column for a bar chart.

Bar1.WidthType = grfWidthColumn

Bar1.WidthCol = 4

Example 2

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

Floating1.WidthType = grfWidthColumn

Floating1.WidthCol = 4

 

Used by: AutoBarChart object, AutoFloatingBarChart object