Chart
«Chart» component allows you to insert charts into the Printing form.
it is based on the two components:
Chart model - it is any chart on the Excel-template worksheet, which will be used as sample format: i.e. chart type (pie, column, combo, etc.), number of Series, styles, colors, shadows, transparency, borders, lines width, relative positioning of the chart elements and other options. For creation, use an Excel application menu: Insert --> Chart .
Dataset («Grid») - it is any «Grid» component from the Form structure, which provides data for the «Chart». In its turn, Columns of the «Grid» are associated with chart Series.
Here is the Example of Chart component use .
Properties tab:
Item «Area in the template»
The item is for binding of «Chart» and the target area in the Excel-template. The target area for «Chart»» can only be within borders of the the upper-level «Pattern». In the Printing form (at runtime), the chart will be placed directly into specified area, using resizing, if required.
For binding, You have to perform next steps successively:
select a required cells in the Excel-template, in which the chart has to be placed;
press a button
located in the item «Area in the template».
Item «Size»
The item is for defining drawing size. Here is two modes:
Fit drawing within area, which defined in the previous item «Area in the template» ;
Get Width and Height dimensions of drawing from context field.
Here Top-Left corner of drawing is anchoring on Top-Left corner of area, which defined in the previous item «Area in the template». Width and Height dimensions of drawing are being transferred from specified context field. Dimensions must be specified in English Metric Units (or EMUs) (for example, default row height is approximally equal 200000 EMU) .
Item «Appearance at runtime»
By default, a Chart is always appearing in the Printing form at runtime. But it is possible to dynamically define a presence of component in the Printing form.
The item is for associating the component appearance (in Printing form at runtime) with value of any context field (the Chart will be output in the Printing form only if the specified context field is not initial).
You have to press a button
and then in the popup search-help You have to choose required context field (so-called Appearance indicator):
If an Appearance indicator has character data type, You are able to set for analyzing just a part of string instead of entire string.
To do that just press a button
and then on a popup window specify a start position and number of characters that should be analized:
Item «Layout options»
By pressing the button, the list of the charts located on the Excel-template worksheet will popup. You have to pick any chart to use it as Chart model (see description on the top of page):
Pressing the button allows to switch between modes of Chart title output:
- Statically. Title will be transferred directly from Chart model to printing form (by default).
- Dynamically. You have to specify context field, which contain value for Chart title.
Pressing the button allows to switch between modes of Category axis title output:
- Statically. Title will be transferred directly from Chart model to printing form (by default).
- Dynamically. Title will be taken from caption of corresponding column of dataset grid header. You can specify context field, which contain value for Category axis title.
Pressing the button allows to switch between modes of Value axis title output:
- Statically. Title will be transferred directly from Chart model to printing form (by default).
- Dynamically. You can specify context field, which contain value for Value axis title.
Pressing the button allows to switch between modes of Series names (in legend) output:
- Statically. Series names will be transferred directly from Chart model to printing form (by default).
- Dynamically. Series names will be taken from captions of corresponding columns of dataset grid header.
Item «Dataset»
In this item you have to define any «Grid» component, based on which will be built the «Chart». In its turn, Columns of the «Grid» are associated with chart Series.
By pressing the button, the list of the «Grid» components located in the form will popup. You have to pick the «Grid», which will provide data for the «Chart».
Note 1: The dataset «Grid» and the «Chart» can be located on the same or on different sheets.
Note 2: If any «Grid» is not in the list, it maybe belongs to another hierarchy level in the context.
By pressing the button, the list of the chart Series (green colored) from Chart model will popup. Here is needed to assign each of chart Series to appropriate column of the Dataset Grid (white colored) :
In addition to Series, you also have to specify the Grid column for the Horizontal (Category) axis labels:
in bottom line, which marked by icon "Arrow":
Explanation: From the screenshort above follows that:
for the Series Occupied data must be taken from column SEATSOCC of the specified «Grid»
for the Series Maximum data must be taken from column SEATSMAX of the specified «Grid»
in the Horizontal axis labels of chart will be Dates from column FLDATE of the specified «Grid» .