Difference between revisions of "Bar Chart"
(9 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
<translate> | <translate> | ||
<!--T:1--> | <!--T:1--> | ||
Line 4: | Line 7: | ||
<!--T:2--> | <!--T:2--> | ||
− | The Bar Chart object needs one [[Date]] or [[Text]] column that will be used to group data and supports [[Value|values]] columns that will be | + | The Bar Chart object needs one [[Date]] or [[Text]] column that will be used to group data and supports [[Value|values]] columns that will be shown as the bars in the chart. |
<!--T:3--> | <!--T:3--> | ||
Line 17: | Line 20: | ||
<!--T:6--> | <!--T:6--> | ||
− | In the above | + | In the example above, the chart displays the ''Net Revenue'' in bars series and the ''Cost'' in area series by ''State''. |
Line 24: | Line 27: | ||
<!--T:8--> | <!--T:8--> | ||
− | In the above | + | In the example above, the chart displays values for the top 4 ([[Row limit]]) products from the previous year ([[Object Filters]]). |
+ | |||
+ | |||
+ | <!--T:17--> | ||
+ | See below all available properties for this object: | ||
+ | |||
+ | |||
+ | <!--T:18--> | ||
+ | * '''Data Properties''': | ||
+ | ** [[Object Filters|Filters]] | ||
+ | ** [[Rows sort|Rows Sort]] | ||
+ | ** [[Column order|Column Order]] | ||
+ | ** [[Drill Down]] | ||
+ | ** [[Total column|Total Column]] | ||
+ | ** [[Advanced row filter|Advanced Row Filter]] | ||
+ | ** [[Row limit|Row Limit]] | ||
+ | |||
+ | |||
+ | <!--T:19--> | ||
+ | * '''Category Axis Properties''': | ||
+ | ** [[Hide labels|Hide Labels]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Labels]] | ||
+ | ** [[Hide Category]] | ||
+ | <!--T:20--> | ||
+ | * '''Values Axis Properties''': | ||
+ | ** [[Decimal_(Y_axis)|Decimals]] | ||
+ | ** [[Thousand_sep._(Y_axis)|Thousand Separator]] | ||
+ | ** [[Maximum Axis Value]] | ||
+ | ** [[Minimum Axis Value]] | ||
+ | ** Invisible | ||
− | |||
− | |||
− | <!--T: | + | <!--T:21--> |
− | * | + | * '''Series Properties''': |
− | * | + | ** [[Font size|Font Size]] |
− | * [[ | + | ** [[Hide labels|Show Labels]] |
− | * | + | ** [[Stacking]] |
− | * [[ | ||
− | |||
− | * | ||
− | * [[Stacking | ||
− | |||
− | |||
− | <!--T: | + | <!--T:22--> |
− | ''' | + | * '''Legend Properties''': |
+ | ** [[Hide Legend]] | ||
+ | ** [[Legend position|Legend Position]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Legend]] | ||
− | |||
− | |||
+ | <!--T:23--> | ||
+ | * '''Title Bar Properties''': | ||
+ | ** [[Title bar Properties|Title Bar Properties]] | ||
− | |||
− | |||
− | <!--T: | + | <!--T:24--> |
− | * [[ | + | * '''Layout Properties''': |
− | * [[Border color]] | + | ** [[Hide Border|Show Border]] |
− | * [[ | + | ** [[Border color|Border Color]] |
− | * | + | ** [[Background color|Background Color]] |
− | * [[ | + | ** [[Object positions|Object Positions]] |
− | * | + | ** [[Object dimensions|Object Dimensions]] |
− | * [[Object dimensions | ||
− | |||
− | <!--T: | + | <!--T:25--> |
− | ''' | + | * '''Column Properties''': |
+ | ** [[Selected column]] | ||
+ | ** [[Column name]] | ||
+ | ** [[Data type|Data Type]] | ||
+ | ** [[Column label|Column Label]] | ||
+ | ** [[Column filters|Column Filters]] | ||
+ | ** [[Delete column|Delete Column]] | ||
+ | ** [[Series Color]] | ||
+ | ** [[Series Type]] | ||
+ | ** [[Function]] | ||
+ | ** [[Decimal places|Decimal Places]] | ||
+ | ** [[Thousand_sep.|Thousand Sep.]] | ||
+ | ** [[Mask]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</translate> | </translate> |
Latest revision as of 15:02, 4 October 2022
A Bar Chart object that represents data as a series of horizontal columns whose height is determined by the values in the data.
The Bar Chart object needs one Date or Text column that will be used to group data and supports values columns that will be shown as the bars in the chart.
For other chart options, see Objects. It is also possible to create combined charts by changing the Series Type property of the Value columns.
Examples
In the example above, the chart displays the Net Revenue in bars series and the Cost in area series by State.
In the example above, the chart displays values for the top 4 (Row limit) products from the previous year (Object Filters).
See below all available properties for this object:
- Data Properties:
- Category Axis Properties:
- Values Axis Properties:
- Series Properties:
- Legend Properties:
- Title Bar Properties:
- Layout Properties: