FormatConditions.AddDatabar Method
Returns a Databar object representing a data bar conditional formatting rule for the specified range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function AddDatabar As Object
'Usage
Dim instance As FormatConditions
Dim returnValue As Object
returnValue = instance.AddDatabar()
Object AddDatabar()
Return Value
Type: System.Object
Databar object
Remarks
Data bars help you see the value of a cell relative to other cells. The length of the data bar represents the value in the cell. A longer bar represents a higher value and a shorter bar represents a lower value. Data bars are useful in spotting higher and lower numbers especially with large amounts of data, such as top and bottom selling toys in a holiday sales report.