ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Chart functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Indicates the type of category in a Waterfall chart.
Example
// 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>: Control name or character string
Name of the chart to be used. This name corresponds to:
  • the chart name defined through programming with grCreate.
  • the name of the Chart control found in the window editor, report editor or page editor.
PHP Only the interactive Chart controls are available.
<Category>: Integer
Number of the category to use.
<Type of category>: Integer constant
Type of category:
grDefaultPositive or negative values of the chart.
grSubTotalSub-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.
grTotalTotal 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: 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:
WD Chart 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.
Component: wd290grf.dll
Minimum version required
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help