11,677
edits
Changes
Importing a new version from external source
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 show 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'''
[[File:colchart_ex.png|link=]]
In the above example the chart displays the ''Quantity'', ''Taxes'' and ''Profit'' by company ''Branch''.
[[File:colchart_ex2.png|link=]]
In this example the chart displays the [[Stacking|Stacked]] values of ''Taxes'' and ''Cost'' by ''Month'' using different [[Layout Properties]].
[[File:combined_chart.png|link=]]
This example shows the 'Cost', 'Profit' and 'Net Revenue' values using different [[Series Type]] (column, area and line).
'''Data Properties'''
* [[Advanced row filter]]
* [[Column order]]
* [[Decimal (Y axis)]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Stacking]]
* [[Thousand sep. (Y axis)]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Background color]]
* [[Border color]]
* [[Font size]]
* [[Hide labels]]
* [[Labels rotation]]
* [[Legend position]]
* [[Object dimensions]]
* [[Object positions]]
'''Object Columns Properties'''
* [[Column filters]]
* [[Column label]]
* [[Column name]]
* [[Data type]]
* [[Decimal places]]
* [[Delete column]]
* [[Function]]
* [[Mask]]
* [[Series Type]]
* [[Thousand sep.]]
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 show 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'''
[[File:colchart_ex.png|link=]]
In the above example the chart displays the ''Quantity'', ''Taxes'' and ''Profit'' by company ''Branch''.
[[File:colchart_ex2.png|link=]]
In this example the chart displays the [[Stacking|Stacked]] values of ''Taxes'' and ''Cost'' by ''Month'' using different [[Layout Properties]].
[[File:combined_chart.png|link=]]
This example shows the 'Cost', 'Profit' and 'Net Revenue' values using different [[Series Type]] (column, area and line).
'''Data Properties'''
* [[Advanced row filter]]
* [[Column order]]
* [[Decimal (Y axis)]]
* [[Object Filters|Filters]]
* [[Row limit]]
* [[Rows sort]]
* [[Stacking]]
* [[Thousand sep. (Y axis)]]
* [[Total row]]
'''Title Bar Properties'''
* [[Title bar Properties]]
'''Layout Properties'''
* [[Background color]]
* [[Border color]]
* [[Font size]]
* [[Hide labels]]
* [[Labels rotation]]
* [[Legend position]]
* [[Object dimensions]]
* [[Object positions]]
'''Object Columns Properties'''
* [[Column filters]]
* [[Column label]]
* [[Column name]]
* [[Data type]]
* [[Decimal places]]
* [[Delete column]]
* [[Function]]
* [[Mask]]
* [[Series Type]]
* [[Thousand sep.]]
