Difference between revisions of "Cross Bar Chart"
(15 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
+ | <translate> | ||
+ | <!--T:1--> | ||
A Cross Bar Chart object that represents data as a series of horizontal columns whose height is determined by the values in the data. | A Cross Bar Chart object that represents data as a series of horizontal columns whose height is determined by the values in the data. | ||
− | The Cross Column Bar object needs two [[ | + | <!--T:2--> |
+ | The Cross Column Bar 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 barra cruzado 1+en-US.PNG]] | ||
+ | |||
+ | <!--T:6--> | ||
+ | In the example above, the chart displays the [[Stacking]] values of ''Quantity'' of Product ''Groups'' by ''State''. | ||
+ | |||
+ | |||
+ | <!--T:7--> | ||
+ | [[File:Gráfico de barra cruzado 2+en-US.PNG]] | ||
+ | |||
+ | <!--T:8--> | ||
+ | In the example above the chart displays the ''Profit'' of ''Product Groups'' by ''State''. | ||
+ | |||
+ | |||
+ | |||
+ | <!--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]] | ||
− | |||
− | * [[Title bar Properties]] | + | <!--T:23--> |
+ | * '''Title Bar Properties''': | ||
+ | ** [[Title bar Properties|Title Bar Properties]] | ||
− | '''Layout Properties''' | + | <!--T:24--> |
+ | * '''Layout Properties''': | ||
+ | ** [[Hide Border|Show Border]] | ||
+ | ** [[Border color|Border Color]] | ||
+ | ** [[Background color|Background Color]] | ||
+ | ** [[Object positions|Object Positions]] | ||
+ | ** [[Object dimensions|Object Dimensions]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | <!--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 Bar Chart object that represents data as a series of horizontal columns whose height is determined by the values in the data.
The Cross Column Bar 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 Stacking values of Quantity of Product Groups by State.
In the example above the chart displays the Profit of Product Groups by State.
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:
- Column Properties: