BAR
Draw a bar within a cell . A bar is only drawn in the cell, if it is the outer function within a formula.
Syntax
=BAR(Value, [Direction], [FillColor], [LineColor])
Arguments
| Name | Type | Description |
|---|---|---|
| Value | Number | Size of bar covering the cell, that the function contains. The size is given as a factor of the height or width between 0 and 1, where 1 will cover the complete cell. Negative vales are allowed. |
| Direction (optional) | BarDirection | Define, if a horizontal or vertical bar shall be displayed Options: 0: Display horizontal bar 1: Display vertical bar Default value: 0 |
| FillColor (optional) | Color | Fill color value. Options: "none": Invisible "#FFFFFF": White "#000000": Black "#FF0000": Red "#00FF00": Green "#0000FF": Blue "#FFFF00": Yellow "#AAAAAA": Grey Default value: "#00FF00" |
| LineColor (optional) | Color | Line color value. Options: "none": Invisible "#FFFFFF": White "#000000": Black "#FF0000": Red "#00FF00": Green "#0000FF": Blue "#FFFF00": Yellow "#AAAAAA": Grey Default value: "none" |
Return
| Type | Description |
|---|---|
| Number | The value passed as the first argument. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 0.5 | Draw a horizontal with with a red fill color filling half the height of the cell. |