Difference between revisions of "Column Chart"
(13 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
<translate> | <translate> | ||
<!--T:1--> | <!--T:1--> | ||
Line 4: | Line 7: | ||
<!--T:2--> | <!--T:2--> | ||
− | The Column Chart object needs one [[Date]] or [[Text]] column that will be used to group data and supports [[Value|values]] columns that will be | + | The Column 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 columns 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 ''Quantity'', ''Taxes'', and ''Profit'' by company ''Branch''. |
Line 24: | Line 27: | ||
<!--T:8--> | <!--T:8--> | ||
− | In this example the chart displays the [[Stacking|Stacked]] values of ''Taxes'' and ''Cost'' by ''Month'' using different [[Layout Properties]]. | + | In this example, the chart displays the [[Stacking|Stacked]] values of ''Taxes'' and ''Cost'' by ''Month'' using different [[Layout Properties]]. |
Line 31: | Line 34: | ||
<!--T:10--> | <!--T:10--> | ||
− | This example shows the 'Cost', 'Profit' and 'Net Revenue' values using different [[Series Type]] (column, area and line). | + | This example shows the 'Cost', 'Profit' and 'Net Revenue' values using different [[Series Type]] (column, area, and line). |
+ | |||
+ | |||
+ | <!--T:19--> | ||
+ | See below all available properties for this object: | ||
+ | |||
+ | |||
+ | <!--T:20--> | ||
+ | * '''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:21--> | ||
+ | * '''Category Axis Properties''': | ||
+ | ** [[Hide labels|Hide Labels]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Labels]] | ||
+ | ** [[Hide Category]] | ||
− | <!--T: | + | <!--T:22--> |
− | ''' | + | * '''Values Axis Properties''': |
+ | ** [[Decimal_(Y_axis)|Decimals]] | ||
+ | ** [[Thousand_sep._(Y_axis)|Thousand Separator]] | ||
+ | ** [[Maximum Axis Value]] | ||
+ | ** [[Minimum Axis Value]] | ||
+ | ** Invisible | ||
− | <!--T: | + | <!--T:23--> |
− | * | + | * '''Series Properties''': |
− | * | + | ** [[Font size|Font Size]] |
− | * [[ | + | ** [[Hide labels|Show Labels]] |
− | * | + | ** [[Show Markers]] |
− | * [[ | + | ** [[Stacking]] |
− | * [[ | ||
− | * | ||
− | * [[Stacking | ||
− | |||
− | |||
− | <!--T: | + | <!--T:24--> |
− | ''' | + | * '''Legend Properties''': |
+ | ** [[Hide Legend]] | ||
+ | ** [[Legend position|Legend Position]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Legend]] | ||
− | |||
− | |||
+ | <!--T:25--> | ||
+ | * '''Title Bar Properties''': | ||
+ | ** [[Title bar Properties|Title Bar Properties]] | ||
− | |||
− | |||
− | <!--T: | + | <!--T:26--> |
− | * [[ | + | * '''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:27--> |
− | ''' | + | * '''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 14:27, 4 October 2022
A Column Chart object that represents data as a series of vertical columns whose height is determined by the values in the data.
The Column 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 columns 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 Quantity, Taxes, and Profit by company Branch.
In this example, the chart displays the Stacked values of Taxes and Cost by Month using different Layout Properties.
This example shows the 'Cost', 'Profit' and 'Net Revenue' values using different Series Type (column, area, and line).
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: