Difference between revisions of "Cross Column Chart"

From TaticView
Jump to: navigation, search
 
(9 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 Cross Column Chart object needs two [[Date]] or [[Text]] columns (or one of each) that will be used to group data and one [[Value]] column that will be show as the columns in the chart.
+
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.
  
  
Line 18: Line 21:
  
 
<!--T:6-->
 
<!--T:6-->
In the above example the chart displays the ''Branch'' ''Profit'' by company ''Product'', showing also the [[Total column]].
+
In the example above, the chart displays the ''Branch'' ''Profit'' by company ''Product'', showing also the [[Total column]].
  
  
Line 25: Line 28:
  
 
<!--T:8-->
 
<!--T:8-->
The second example displays the ''Products'' ''Net Revenue'' by ''Year'', showing also the [[Total column]].
+
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:9-->
 
'''Data Properties'''
 
  
<!--T:10-->
+
<!--T:21-->
* [[Advanced row filter]]
+
* '''Series Properties''':
* [[Average Column]]
+
** [[Font size|Font Size]]
* [[Label (series)]]
+
** [[Hide labels|Show Labels]]
* [[Decimal (Y axis)]]
+
** [[Show Markers]]
* [[Object Filters|Filters]]
+
** [[Stacking]]
* [[Row limit]]
 
* [[Rows sort]]
 
* [[Stacking]]
 
* [[Thousand sep. (Y axis)]]
 
* [[Total column]]
 
* [[Total row]]
 
  
  
<!--T:11-->
+
<!--T:22-->
'''Title Bar Properties'''
+
* '''Legend Properties''':
 +
** [[Hide Legend]]
 +
** [[Legend position|Legend Position]]
 +
** [[Font size|Font Size]]
 +
** [[Abbreviate Legend]]
  
<!--T:12-->
 
* [[Title bar Properties]]
 
  
 +
<!--T:23-->
 +
* '''Title Bar Properties''':
 +
** [[Title bar Properties|Title Bar Properties]]
  
<!--T:13-->
 
'''Layout Properties'''
 
  
<!--T:14-->
+
<!--T:24-->
* [[Background color]]
+
* '''Layout Properties''':
* [[Border color]]
+
** [[Hide Border|Show Border]]
* [[Font size]]
+
** [[Border color|Border Color]]
* [[Hide labels]]
+
** [[Background color|Background Color]]
* [[Object dimensions]]
+
** [[Object positions|Object Positions]]
* [[Labels rotation]]
+
** [[Object dimensions|Object Dimensions]]
* [[Legend position]]
 
* [[Object positions]]
 
  
  
<!--T:15-->
+
<!--T:25-->
'''Object Columns Properties'''
+
* '''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]]
  
<!--T:16-->
 
* [[Column filters]]
 
* [[Column label]]
 
* [[Column name]]
 
* [[Data type]]
 
* [[Decimal places]]
 
* [[Delete column]]
 
* [[Function]]
 
* [[Mask]]
 
* [[Series Type]]
 
* [[Thousand sep.]]
 
 
</translate>
 
</translate>

Latest revision as of 13:49, 6 October 2022

Other languages:
English • ‎português do Brasil


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

Gráfico de coluna cruzado 1+en-US.PNG

In the example above, the chart displays the Branch Profit by company Product, showing also the Total column.


Gráfico de coluna cruzado 2+en-US.PNG

The second example displays the Products Net Revenue by Year, also showing the Total column.


See below all available properties for this object: