11,677
edits
Changes
Importing a new version from external source
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 [[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.
For other chart options, see [[Objects]].
'''Example'''
[[File:ccolchart_ex.png|link=]]
In the above example the chart displays the ''Products'' ''Gross Sale'' by company ''Branch'', showing also the [[Total column]].
[[File:ccolchart_ex2.png|link=]]
The second example displays the ''Products'' sales value by ''Year''.
'''Data Properties'''
* [[Advanced row filter]]
* [[Average Column]]
* [[Decimal (Y axis)]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Stacking]]
* [[Thousand sep. (Y axis)]]
* [[Total column]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Background color]]
* [[Border color]]
* [[Font size]]
* [[Hide labels]]
* [[Object dimensions]]
* [[Labels rotation]]
* [[Legend position]]
* [[Object positions]]
'''Object Columns Properties'''
* [[Column filters]]
* [[Column label]]
* [[Column name]]
* [[Data type]]
* [[Decimal places]]
* [[Delete column]]
* [[Function]]
* [[Mask]]
* [[Series Type]]
* [[Thousand sep.]]
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.
For other chart options, see [[Objects]].
'''Example'''
[[File:ccolchart_ex.png|link=]]
In the above example the chart displays the ''Products'' ''Gross Sale'' by company ''Branch'', showing also the [[Total column]].
[[File:ccolchart_ex2.png|link=]]
The second example displays the ''Products'' sales value by ''Year''.
'''Data Properties'''
* [[Advanced row filter]]
* [[Average Column]]
* [[Decimal (Y axis)]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Stacking]]
* [[Thousand sep. (Y axis)]]
* [[Total column]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Background color]]
* [[Border color]]
* [[Font size]]
* [[Hide labels]]
* [[Object dimensions]]
* [[Labels rotation]]
* [[Legend position]]
* [[Object positions]]
'''Object Columns Properties'''
* [[Column filters]]
* [[Column label]]
* [[Column name]]
* [[Data type]]
* [[Decimal places]]
* [[Delete column]]
* [[Function]]
* [[Mask]]
* [[Series Type]]
* [[Thousand sep.]]