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
CHART_Waterfall.AddData(1, 1, 298000)
CHART_Waterfall.CategoryLabel(1, "TO 2017")
 
// Add the profits
CHART_Waterfall.AddData(1, 2, 420000)
CHART_Waterfall.CategoryLabel(2, "Profits" + CR + "products")
CHART_Waterfall.AddData(1, 3, 210000)
CHART_Waterfall.CategoryLabel(3, "Profits" + CR + "services")
 
// Costs
CHART_Waterfall.AddData(1, 4, -170000)
CHART_Waterfall.CategoryLabel(4, "Fixed costs")
CHART_Waterfall.AddData(1, 5, -140000)
CHART_Waterfall.CategoryLabel(5, "Variable costs")
 
// TO 2018
CHART_Waterfall.AddData(1, 6, 0)
CHART_Waterfall.CategoryLabel(6, "TO 2018")
CHART_Waterfall.WaterfallCategoryType(6, grSubTotal)
 
// Cumulated TO
CHART_Waterfall.AddData(1, 7, 0)
CHART_Waterfall.CategoryLabel(7, "Cumulated TO")
CHART_Waterfall.WaterfallCategoryType(7, grTotal)
Syntax
<Chart control>.WaterfallCategoryType(<Category> , <Type of category>)
<Chart control>: Control name
Name of the Chart control 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 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help