Charts - Area, Line or Stick

General - Area, Line and Stick

The graphic function of DataChain is accessible from the presentation module HandleData Logo HandleData

The number of Charts DataChain is not limited.

This function is used to represent data sources (DataBlock) in the form of an Area, Line or Bar type graph.

3 types of graph are available:

Icone ChartArea Area Icon Chartline Line Icone ChartBar Stick

In the same way as the other presentations (TimeLines, (Maps, Indicators, etc.), graphs, once created, can be integrated into the xref module :dashboard.adoc[Dashboards]

Creating an Area, Line or Bar graph

List of existing graphics

The creation of a graph (like all operations on presentations) is carried out from the HandleData module handleData-color.png

Step 1

  • Access HandleData module Logo HandleData

  • 1 Choose, in the left menu, the Chart option associated with the icon chart-line

  • 2 Click on the button New

Access to the list of graphics

Metadata

2nd step

  • A screen allows you to choose the type of graph you want. To create a Line, Bar or Area type graph, click on one of the following icons: choice chart

  • Each graph has metadata. inforougee Entering a label is required.

View Metadata

Optional input areas allow more description to be given to the graph. An icon can also be assigned to a chart’s metadata.

  • information It is advisable to save the metadata as soon as you enter it. Use the button Save button located in the right part of the top banner of the presentation screen.

Tab - Data Sources

Step 3

  • At least one data source is required to create a chart.

Use the btn-ajouter-source.svg[add source] icon to access the list of available sources. (cf Datablock Documentation)

information The sources offered are related to the rights of the current user.

information It is possible to integrate, on the fly, a file with a separator. To do this, use the function Rapid Integration via the icon magic located in the top banner of the HandleData application.

1 Sources are powered by DataBlocks. It is possible, at the level of each source, to carry out operations making it possible to adapt, for a presentation, the blocks of original data by clicking on the icon Icone edit
The Dates display format must be defined in the third step to be visible in the Viewer.

2 Displays a succession of operations such as generation of formulas, filters, aggregations, sorting and modification of labels and types are available.
The Dates display format must be defined in the third step to be visible in the Viewer.

Source Operations Handle

Step 4

The list of available sources is presented in the form of a table. In the proposed list, choose one (or more) sources then double-click on the line or use the button Validate to assign the source to the graphic.

Choice of sources

1 Refreshes the list of available sources 2 Used to validate the source assignment It is necessary, before validating the assignment to choose a source by selecting a line in the table of sources. three Returns to the list of sources assigned to the graph.

  • information Unlike TimeLines or Maps, only one source can be assigned to graphics.

    Step 4 Bis (optional)

    • If necessary, the user can make changes to the chosen sources.

    • In this case, select one of the sources assigned to the current graph. Use the icon edit located at the end of the line (or click on source label). Then make the necessary changes. Save the changes using the Validate button then the Back button icon to return to the list of sources for the current graph.

Tab - Settings

General

General graphics parameters

  • Caption and titles

    • Title: Chart title.

      • Font: Character font used for the chart title.

      • Color: Chart title color.

      • Size: Chart title font size.

    • Subtitle: Subtitle of the graph

      • Font: Character font used for the graph subtitle.

      • Color: Color of the subtitle of the graph subtitle of the graph.

    • Palette: Color palette associated with the chart.

    • Caption: Specifies whether the caption is visible or not.

      • Frame: Specifies the presence of a frame around the legend.

      • Position: Specifies the position of the legend.

        • or inside the chart (Interior).

        • or outside the graph (Outside).

      • Orientation: Specifies the orientation of the legend either

        • horizontal

        • vertical

      • Vertical alignment: Specifies whether the legend is located either

        • up (up)

        • down (Down)

        • or centered (Centered)

      • Horizontal alignment: Specifies whether the legend is located either

        • right (Right)

        • left (left)

        • or centered (Centered)

    • Zoom: Specifies whether the zoom is active or inactive.

    • Scroll: Specifies whether the scroll is active or inactive.

    • Export: Specifies whether the panel used to export the graph is active or inactive. Possible exports are: PNG, JPEG, PDF, SVG and print module

    • Inverted: Rotates the graph by 90°. The ordinate becomes a horizontal axis and the abscissa becomes a vertical axis.

    • Tooltip: tag.svg Allows to define the content of the tooltip. All the source columns can be integrated into the tooltip.

*rea, Line and Stick Setup

Advanced graphics settings

  • Chart Type Warning Area Required

    1 This area lets you choose the type of line, bar or area that is used for the graph.

    Spline Area
Stacked Area
Normalized Stacked Area
Stacked Spline Area
Normalized Stacked Spline Area
Area
    Stick
Stacked Stick
Standard Stacked Sticks
    Line
Spline
Stacked Line
Spline Stacked Line
Normalized Stacked Line
Normalized Spline Stacked Line
Slot Line

Options are available to specify

  • if a circle is present at each point of the line

  • the representation color of the series

  • the style of the series: continuous, dotted or made up of dashes

  • Abscissa: (x axis)

    • Title: Specifies a name for the abscissa axis.

    • Type: Specifies the Character string, Numeric or Date type of the abscissa values. information Note that the choice of type determines the behavior of the axis (especially the sorting of the axis).

    • Inverted: Inverts the order of x-axis values.

    • Position: Repositions the abscissa axis. Depending on whether or not the graph is inverted, two cases are possible:

      • If the graph is reversed, the abscissa can be located on the right or on the left.

      • If the graph is not inverted, the absciss can be located at top or bottom.

    • Type: Specifies the type of the y-axis. 3 options are possible:

      • Continued

      • Normal

      • Logarithmic _Displays numerical values. Each value is the logarithmBase value raised to some power. For example, logarithmBase equal to 10 generates the following values: 10-2, 10-1, 100, 101, 102, etc. The logarithmic axis is useful when viewing a dataset of rapidly growing values.

    • Crossover Area: The crossover area is a pointer represented by two intersecting lines that span the entire graph. The two lines help the user identify series point values accurately. When enabled, both lines follow the cursor and snap to the nearest series point.

    • Style of the intersection zone: Allows you to define the presentation format of the intersection zone either

      • Hyphen

      • Point

      • Long dash

      • Continued

    • Label

      • Mode: Specifies the display mode for the abscissa labels. 3 choices are possible:

        • Normal: The labels are positioned on a single line.

        • Rotated: The labels are positioned according to an angle (90° by default). The angle value must be specified in the Angle field.

        • On two lines: The labels are positioned on two lines.

      • Angle: if the mode is equal to Rotated, specifies the value of the label inclination angle.

      • Wordwrap: Specifies the behavior of the label in the event of a long label. 3 values are possible:

        • Between words: The text only breaks at authorized breakpoints (for example, a space between two words).

        • Automatic: Words may be broken if there are no breakpoints available in the line.

        • None: Word wrap is disabled.

  • Ordinate (y-axis)

    • Title: Allows naming of the ordinate axis.

    • Type: Specifies the Character string, Numeric or Date type of the ordinate values.

    • Reversed: Reverses the order of the y-axis values.

    • Position: Reposition the ordinate axis. Several possibilities depending on the position inverted or not of the graph. If the graph is inverted then the ordinate can be either up or down. If the graph is not inverted then the ordinate can be right or left.

    • Type: Specifies the type of the y-axis. 3 choices are possible:

      • Continued

      • Normal

      • Logarithmic _Displays numerical values. Each value is the raised logarithmBase value with some power. For example, logarithmBase equal to 10 generates the following values: 10-2, 10-1, 100, 101, 102, etc. The logarithmic axis is useful when viewing a dataset of rapidly growing values.

    • Start value: Used to specify the start value of the y-axis.

  • 2 Constants: The line of constant option is used to position n lines of constants on the y-axis. Each line of constant is defined a title, a value, a style and a color.

    • Title: Label of the constant line.

    • Value: Value (integer number) of the constant.

    • Style: Several styles are possible. Solid, Long Dash, Dash, Period, Dash and Period, Long Dash and Period

    • Color: Specifies the color of the constant line.

    • Thickness: Specifies the thickness of each constant line.

  • 3 Series: Allows you to add one or more series(es) of values on the same abscissa. For each series, the following options are possible:

    • A title

    • The value to represent (choice among the columns of the source)

    • Chart type

    • The presence of dot

    • The color of the representation

    • The aspect of the representation

    • Separate axis: Option that allows you to specify whether the ordinate axis of this new series must be separated.

Click on the Validate button to save the settings

Tab - Visualization

Allows you to view the graph according to the parameters defined.

Onglet visualization

Editing a DataChain chart

  • HandleData module. Chart menu chart-line

  • At the level of the list of graphics, find the graphic in the list. it is possible to use the search and sort functions present at the level of each column.

  • Select line

  • Click on the graphic label or on the edit icon at the end of the line.

Deleting a chart

  • Module HandleData Logo HandleData. Chart menu chart-line

  • At the level of the list of graphics, search for the graphic to be deleted. it is possible to use the search and sort functions present at the level of each column.

  • Select the line.

    • Option 1: Use the suppression icon button at the end of the line and confirm the action.

    • Option 2: Click on the chart label or on the edit icon at the end of the line.

      • Once in Chart Editing. Click on the Delete button and confirm the action.

Quick Reference

Creation of a Line, Bar or Area type chart Choice of chart

From HandleData module Logo HandleData

Steps Objective Stock Landmarks

1

Access to the list of graphics

Click on Chart icon

chart-line

2

New Chart

Click on icon New

New

3

Choose a chart type

Click on one of the icons

Choice of chart

4

The metadata

Enter information

Description Required

5

Assigning a source

Click on icon New source

Add source

6

Chart settings

Click on Settings tab

7

Visualization of the graph

Click on tab Visualization