Difference between revisions of "Line Chart/en"
(Updating to match new version of source page) |
|||
(32 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | <languages/> | |
− | The Line Chart object needs one [[Date]] or [[Text]] column that will be used to group data and supports [[Value|values]] columns that will be | + | |
+ | A Line Chart object that represents data as a series of lines connected dots whose height is determined by the values in the data. | ||
+ | |||
+ | The Line Chart object needs one [[Date]] or [[Text]] column that will be used to group data and supports [[Value|values]] columns that will be shown as the lines and dots 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. | For other chart options, see [[Objects]]. It is also possible to create combined charts by changing the [[Series Type]] property of the [[Value]] columns. | ||
Line 8: | Line 11: | ||
'''Examples''' | '''Examples''' | ||
− | [[File: | + | [[File:linechart_ex.png|link=]] |
+ | |||
+ | In the example above, the chart displays the ''Net Revenue'' and ''Cost'' by ''Month'' in 2017 (filtered with the help of the [[Combo (Filter)]] object). | ||
+ | |||
+ | |||
+ | [[File:Smoothed line.png|link=]] | ||
+ | |||
+ | Like the fist sample, the image above, shows a Line Chart displays the ''Net Revenue'' and ''Cost'' by ''Month'' in 2022 using ''smoothed Lines'' | ||
+ | |||
+ | |||
+ | [[File:combined_chart.png|link=]] | ||
+ | |||
+ | This example shows the ''Cost'', ''Profit'' and ''Net Revenue'' values using different [[Series Type]] (column, area, and line) for the [[Combo (Filter)|year selection]]. | ||
+ | |||
+ | |||
+ | [[File:linechart_ex2.png|link=]] | ||
− | + | This example shows the ''Profit'' performance using different [[Column filters]] for each value to display each ''Branch'' and the general performance (no filter). | |
− | + | See below all available properties for this object: | |
− | |||
+ | * '''Data Properties''': | ||
+ | ** [[Object Filters|Filters]] | ||
+ | ** [[Rows sort|Rows Sort]] | ||
+ | ** [[Column order|Column Order]] | ||
+ | ** [[Drill Down]] | ||
+ | ** [[Total column|Total Column]] | ||
+ | ** [[Advanced row filter|Advanced Row Filter]] | ||
+ | ** [[Row limit|Row Limit]] | ||
− | |||
− | + | * '''Category Axis Properties''': | |
+ | ** [[Hide labels|Hide Labels]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Labels]] | ||
+ | ** [[Hide Category]] | ||
− | ''' | + | * '''Values Axis Properties''': |
+ | ** [[Decimal_(Y_axis)|Decimals]] | ||
+ | ** [[Thousand_sep._(Y_axis)|Thousand Separator]] | ||
+ | ** [[Maximum Axis Value]] | ||
+ | ** [[Minimum Axis Value]] | ||
+ | ** Invisible | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | * '''Series Properties''': | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Hide labels|Show Labels]] | ||
+ | ** [[Stacking]] | ||
− | |||
− | * [[ | + | * '''Legend Properties''': |
+ | ** [[Hide Legend]] | ||
+ | ** [[Legend position|Legend Position]] | ||
+ | ** [[Font size|Font Size]] | ||
+ | ** [[Abbreviate Legend]] | ||
− | ''' | + | * '''Title Bar Properties''': |
+ | ** [[Title bar Properties|Title Bar Properties]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | * '''Layout Properties''': | ||
+ | ** [[Hide Border|Show Border]] | ||
+ | ** [[Border color|Border Color]] | ||
+ | ** [[Background color|Background Color]] | ||
+ | ** [[Object positions|Object Positions]] | ||
+ | ** [[Object dimensions|Object Dimensions]] | ||
− | |||
− | * [[Column | + | * '''Column Properties''': |
− | * [[Column label]] | + | ** [[Selected column]] |
− | * [[Column | + | ** [[Column name]] |
− | * [[ | + | ** [[Data type|Data Type]] |
− | * [[ | + | ** [[Column label|Column Label]] |
− | * [[ | + | ** [[Column filters|Column Filters]] |
− | * [[Function]] | + | ** [[Delete column|Delete Column]] |
− | * [[ | + | ** [[Series Color]] |
− | * [[ | + | ** [[Series Type]] |
− | * [[ | + | ** [[Function]] |
+ | ** [[Decimal places|Decimal Places]] | ||
+ | ** [[Thousand_sep.|Thousand Sep.]] | ||
+ | ** [[Mask]] |
Latest revision as of 02:25, 5 October 2022
A Line Chart object that represents data as a series of lines connected dots whose height is determined by the values in the data.
The Line Chart object needs one Date or Text column that will be used to group data and supports values columns that will be shown as the lines and dots 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
In the example above, the chart displays the Net Revenue and Cost by Month in 2017 (filtered with the help of the Combo (Filter) object).
Like the fist sample, the image above, shows a Line Chart displays the Net Revenue and Cost by Month in 2022 using smoothed Lines
This example shows the Cost, Profit and Net Revenue values using different Series Type (column, area, and line) for the year selection.
This example shows the Profit performance using different Column filters for each value to display each Branch and the general performance (no filter).
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: