<Chart>.WaterfallCategoryType (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Functions for managing charts

WLanguage functions

Prefixed syntax

WaterfallCategoryType

AutoRefreshCategoryLabel

Scatter3DAltitudeColor

Scatter3DDeleteAltitudeColor

Scatter3DDeleteMarkCaption

SurfaceDeleteAltitudeColor

SurfaceDeleteMarkCaption

WaterfallCategoryType

WaterfallColor

Zoom

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Chart>.WaterfallCategoryType (Function)

In french: <Graphe>.WaterfallTypeCatégorie

Indicates the type of category in a Waterfall chart.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

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.

<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 shows the different uses of the chart control.
The following charts are presented:
- Semi-circular
- Donut
- Pie
- Sunburst
- Line
- Scatter
- 3D Scatter
- Column
- Area
- Bubble
- Radar
- Funnel
- Surface
- Waterfall
- Composite
- Comparative

The main features presented in this example are the customization of charts by programming, as well as the method used to fill a chart from an HFSQL file or in the editor.

Component : wd250grf.dll