grWaterfallCategoryType (Function) In french: grWaterfallTypeCatégorie Indicates the type of category in a Waterfall chart.  Versions 21 and later New in version 21
// TO 2017
grAddData(CHART_Waterfall, 1, 1, 298000)
grCategoryLabel(CHART_Waterfall, 1, "TO 2017")
// Add the profits
grAddData(CHART_Waterfall, 1, 2, 420000)
grCategoryLabel(CHART_Waterfall, 2, "Profits" + CR + "products")
grAddData(CHART_Waterfall, 1, 3, 210000)
grCategoryLabel(CHART_Waterfall, 3, "Profits" + CR + "services")
// Costs
grAddData(CHART_Waterfall, 1, 4, -170000)
grCategoryLabel(CHART_Waterfall, 4, "Fixed costs")
grAddData(CHART_Waterfall, 1, 5 -140000)
grCategoryLabel(CHART_Waterfall, 5, "Variable costs")
// TO 2018
grAddData(CHART_Waterfall, 1, 6, 0)
grCategoryLabel(CHART_Waterfall, 6, "TO 2018")
grWaterfallCategoryType(CHART_Waterfall, 6, grSubTotal)
// Cumulated TO
grAddData(CHART_Waterfall, 1, 7, 0)
grCategoryLabel(CHART_Waterfall, 7, "Cumulated TO")
grWaterfallCategoryType(CHART_Waterfall, 7, grTotal)
Syntax
grWaterfallCategoryType(<Chart name> , <Category> , <Type of category>)
<Chart name>: Character string (with or without quotes) Name of chart to use. This name corresponds to:- the chart name defined by programming with grCreate.
- the name of the Chart control found in the window editor, report editor or page editor.
<Category>: Integer Number of the category to use. <Type of category>: Integer constant Type of category:
| | | grDefault | Positive or negative values of the chart. | | grSubTotal | Sub-total values. If the category corresponds to a sub-total, the value stored for this category is ignored. For this category, the Waterfall chart displays a bar corresponding to the sum of all previous categories from the last total or sub-total. | | grTotal | Total values. If the category corresponds to a total, the value stored for this category is ignored. For this category, the Waterfall chart displays a bar corresponding to the sum of all previous categories from the beginning of the chart. |
Remarks - Special case: the first category
The first category is always a "total" category but the specified value is displayed: it is the start value. - This function applies to the Waterfall charts only.
Related Examples:
|
Training (WINDEV): WD Chart
[ + ] This example presents the different uses of the Chart control. Different types of charts are presented: - Pie - Sunburst - Line - Scatter - Column - Area - etc. The main features presented here are the possibility to customize of charts from the code, as well as to fill the chart from an HFSQL data file, or in the editor.
|
This page is also available for…
|
|
|