Difference between revisions of "Cross Column Chart"
(13 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
+ | <translate> | ||
+ | <!--T:1--> | ||
A Cross Column Chart object that represents data as a series of grouped vertical columns whose height is determined by the values in the data. | A Cross Column Chart object that represents data as a series of grouped vertical columns whose height is determined by the values in the data. | ||
− | The Cross Column Chart object needs two [[ | + | <!--T:2--> |
+ | The Cross Column Chart object needs two [[Dates]] or [[Texts]] columns (or one of each) that will be used to group data and one [[Value]] column that will be shown as the columns in the chart. | ||
+ | <!--T:3--> | ||
For other chart options, see [[Objects]]. | For other chart options, see [[Objects]]. | ||
+ | <!--T:4--> | ||
'''Example''' | '''Example''' | ||
− | [[File: | + | <!--T:5--> |
+ | [[File:Gráfico de coluna cruzado 1+en-US.PNG]] | ||
+ | |||
+ | <!--T:6--> | ||
+ | In the example above, the chart displays the ''Branch'' ''Profit'' by company ''Product'', showing also the [[Total column]]. | ||
+ | |||
+ | |||
+ | <!--T:7--> | ||
+ | [[File:Gráfico de coluna cruzado 2+en-US.PNG]] | ||
+ | |||
+ | <!--T:8--> | ||
+ | The second example displays the ''Products'' ''Net Revenue'' by ''Year'', also showing the [[Total column]]. | ||
+ | |||
+ | |||
+ | |||
+ | <!--T:17--> | ||
+ | See below all available properties for this object: | ||
+ | |||
− | + | <!--T:18--> | |
+ | * '''Data Properties''': | ||
+ | ** [[Object Filters|Filters]] | ||
+ | ** [[Rows sort|Rows Sort]] | ||
+ | ** [[Average Column]] | ||
+ | ** [[Total column|Total Column]] | ||
+ | ** [[Total row|Total Row]] | ||
+ | ** [[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:21--> | |
− | * | + | * '''Series Properties''': |
− | * | + | ** [[Font size|Font Size]] |
− | * [[ | + | ** [[Hide labels|Show Labels]] |
− | * | + | ** [[Show Markers]] |
− | * [[ | + | ** [[Stacking]] |
− | * | ||
− | * [[ | ||
− | * | ||
− | * [[ | ||
− | ''' | + | <!--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:24--> |
− | * [[Border color]] | + | * '''Layout Properties''': |
− | * [[ | + | ** [[Hide Border|Show Border]] |
− | * | + | ** [[Border color|Border Color]] |
− | * [[Object | + | ** [[Background color|Background Color]] |
− | * | + | ** [[Object positions|Object Positions]] |
− | + | ** [[Object dimensions|Object Dimensions]] | |
− | * [[Object | ||
− | ''' | + | <!--T:25--> |
+ | * '''Column Properties''': | ||
+ | ** [[Selected column]] | ||
+ | ** [[Column name]] | ||
+ | ** [[Data type|Data Type]] | ||
+ | ** [[Column label|Column Label]] | ||
+ | ** [[Column filters|Column Filters]] | ||
+ | ** [[Delete column|Delete Column]] | ||
+ | ** [[Function]] | ||
+ | ** [[Decimal places|Decimal Places]] | ||
+ | ** [[Thousand_sep.|Thousand Sep.]] | ||
+ | ** [[Series Type]] | ||
+ | ** [[Mask]] | ||
− | + | </translate> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 13:49, 6 October 2022
A Cross Column Chart object that represents data as a series of grouped vertical columns whose height is determined by the values in the data.
The Cross Column Chart object needs two Dates or Texts columns (or one of each) that will be used to group data and one Value column that will be shown as the columns in the chart.
For other chart options, see Objects.
Example
In the example above, the chart displays the Branch Profit by company Product, showing also the Total column.
The second example displays the Products Net Revenue by Year, also showing the Total column.
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: