Difference between revisions of "Column Chart"
(23 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
+ | <translate> | ||
+ | <!--T:1--> | ||
A Column Chart object that represents data as a series of vertical columns whose height is determined by the values in the data. | 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 [[Value|values]] columns that will be | + | <!--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 shown as the columns in the chart. | ||
+ | |||
+ | <!--T:3--> | ||
+ | For other chart options, see [[Objects]]. It is also possible to create combined charts by changing the [[Series Type]] property of the [[Value]] columns. | ||
+ | |||
+ | |||
+ | <!--T:4--> | ||
+ | '''Examples''' | ||
+ | |||
+ | <!--T:5--> | ||
+ | [[File:Gráfico de coluna 1+en-US.PNG]] | ||
+ | |||
+ | <!--T:6--> | ||
+ | In the example above, the chart displays the ''Quantity'', ''Taxes'', and ''Profit'' by company ''Branch''. | ||
+ | |||
+ | |||
+ | <!--T:7--> | ||
+ | [[File:Gráfico de coluna 2+en-US.PNG]] | ||
+ | |||
+ | <!--T:8--> | ||
+ | In this example, the chart displays the [[Stacking|Stacked]] values of ''Taxes'' and ''Cost'' by ''Month'' using different [[Layout Properties]]. | ||
+ | |||
+ | |||
+ | <!--T:9--> | ||
+ | [[File:Gráfico de área 2+en-US.PNG]] | ||
+ | |||
+ | <!--T:10--> | ||
+ | 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:22--> |
+ | * '''Values Axis Properties''': | ||
+ | ** [[Decimal_(Y_axis)|Decimals]] | ||
+ | ** [[Thousand_sep._(Y_axis)|Thousand Separator]] | ||
+ | ** [[Maximum Axis Value]] | ||
+ | ** [[Minimum Axis Value]] | ||
+ | ** Invisible | ||
− | * | + | <!--T:23--> |
− | * | + | * '''Series Properties''': |
− | * [[ | + | ** [[Font size|Font Size]] |
− | * | + | ** [[Hide labels|Show Labels]] |
− | * [[ | + | ** [[Show Markers]] |
− | * | + | ** [[Stacking]] |
− | * [[ | ||
− | * | ||
− | * [[ | ||
− | ''' | + | <!--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:26--> |
− | * [[Border | + | * '''Layout Properties''': |
− | * [[ | + | ** [[Hide Border|Show Border]] |
− | * | + | ** [[Border color|Border Color]] |
− | * [[ | + | ** [[Background color|Background Color]] |
− | * | + | ** [[Object positions|Object Positions]] |
− | * [[Object | + | ** [[Object dimensions|Object Dimensions]] |
− | * | ||
− | * [[ | ||
− | ''' | + | <!--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> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
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: