Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

Basically, there are two possibilities to maintain the features of graphomate charts for Excel :with the Basic Properties Sheet, which lists all parameters in a structured list or with the Additional Properties Sheet. The latter provides a user-friendly interface. There are some special features, which can only be maintained on the Basic Properties Sheet.

The Checkboxes next to the features in the Additional Properties Sheet are used to control the visibility of chart elements.


General Tab

Orientation

All charts can be used in horizontal or vertical orientation:
  • horizontal for development over time,
  • vertical for structure comparison.

Use the toggle button to select Structure/Time.

Chart Type

Choose the preferred chart type via mouse click on the corresponding icon. With the Checkbox
Base Chart you can display or hide the Base Chart. This way, you may use deviation charts without the Base Chart.

Deviations Configuration

These Checkboxes activate - additionally to the Base Chart - axes for absolute or percentage deviations of two Data Series. A click on Name enables the renaming of the deviation series. This Name is also used as a legend. Use the dropdown
boxes to choose the Data Series for the calculation of deviations according to the formulas on the right. Click the button Type for selecting between absolute and percentage deviation. Delete deviation series by using the red button and add new by using the green button, which will be shown above the Base Chart.The order of the display corresponds with the order in the Deviations Configuration.

Formula for calculation of absolute deviation:

Formula for calculation of percentage deviation:

Data Tab

Data Series

Here you can link up to 10 Data Series from the Data Source that you want to display by clicking the corresponding button series n. The Checkbox next to the Data Series determines its visibility in the chart. Change the name of the Data Series by clicking on it. The given names are also used for the Data labels. The x deletes the assignment of the Data Series. More information about the selection of Data Series can be found on page .


Category Labels

Category Labels are shown in the chart, when the Checkbox is activated. Category Labels are automatically created from the meta data of the Data Source.

Base Chart Axis Labels

Define additional axis labeling here. To show these labels the Checkboxes on the Helper Tab must be activated.

Data Types

Specify here the Data Type of each element of the selected Data Series. Each element can be formatted individually. Data Types are defined on the tab Data Types. The entered Data Types are converted to uppercase in the background, so they are not case-sensitive in order to prevent possible sources of errors.


Waterfall Calculation Path

To use a waterfall flexibly, it must be first determined whether the value to be displayed is either a total or an in- or outflow using an additional Data Series. This is carried out by using our so-called Waterfall Calculation Path (see input options on the right and further notes under Introductory Examples and Appendix)


Values for the Waterfall Calculation Path:

Appearance Tab

Labels

Set the font size, the font family and the font color for labels in the chart. In addition, shadows with defined colors can be added to accentuate the labels if the background is colored.


Element Labels

If the Checkbox is activated, all elements of the chart will be labeled. The toggle buttons Fix/Auto determines the visibility of the labels:

  • Fix
    Data labels are always visible.

  • Auto
    Labels are hidden or moved in case of overlaps – adjustable with the property Collision Adjustment


Value Format

Select the format of the Category Labels:

  • Basic

Select the format of the absolute and percentage values according to guidelines of numeral.js. Locale sets the label country format in the Basic mode. de, fr, en and auto are available options. Choosing auto the Locale is retrieved from the Data Source.

  • Extended

If a fixed format is preferred, put the format for absolute and percentage values here.Choosing a "(" in the box Negative Sign will show negative values in brackets: (1234). The parameter in the box Scaling is used as a divisor for scaling the data label. The resulting format string can also be set via VBA scripting – for further details see the appendix on page .

Waterfall

The colors of the elements of a waterfall can be set here - corresponding to the calculation path. Please note that the use of Data Types overlap this standard format.

Deviations

Set the colors for deviations. If positive deviations between measures and base values are not regarded as positive, for example for comparisons of actual vs. budget costs, activate the Checkbox Invert.

Outlier Mode

Choose the appearance of the outliers here. In the mode Short the outliers are shown as small triangles on the axis. In the mode Long they are drawn over the entire available area – according to the rules by IBCS.


Series Styles Editor

In this editor the appearance of the Data Series is determined, as long as you do not use Data Types. Data Types overwrite the Series Styles. The handling is similar to the definition of Data Types on the Data Types tab, the name is derived from the data series name.

Color, Fill and Shape determine the appearance of the elements. Shape refers to the pin heads. Navigate via mouse click through the alternative representations. Width determines the width of the elements. The values can be given in percentage of the category width as well as in absolute values in [px] – just toggle %/abs.

The parameter Width can only be used in bar or column charts. If necessary, please use the parameter Bar Width in the Basic Properties Sheet for the elements width of other chart types.



Data Types Tab

Data Types Editor

This editor is used to define Data Types. The abbreviations can be used on the tab Data and it is possible to format each element individually. The abbreviations are defined in the column Name. Color, Fill und Shape define the appearance of the elements. Shape refers to pin or line heads. Navigate via mouse click through the alternative representations and view the changes in the chart, after you assigned the corresponding Data Type. The column Width determines the width of the elements. The values can be given in percentage of the category width as well as in absolute values in [px] – just toggle %/abs. The last column Bold sets the font type of the label of the Data Type to bold. With the red button next to Data Type you delete Data Types and with the green one you add new Data Types. Data Types are used globally within an Excel workbook. For this reason Data Types will automatically be adopted for all other graphomate components which use Data Types.


Behavior Tab

Scaling

The default Auto scales the chart according to the Min and Max-values of all selected data. Several charts can be scaled identically by using the same Comparison Group, which is activated by the Checkbox. The Comparision Group will then be shown during design time on the top right corner of the chart. That way the Min and Max of the data basis in this group is used. Comparison Groups are used globally within the BIApp, i. e. also deviation charts in the graphomate tables are scaled identically by using the same Comparison Group abbreviation. Alternatively it is possible to set the Min and Max scaling values under Manual. Retrieve values proposes valid values! Chart Min values > "0" cut the value axis. The script method getClickedPositionValue enables an interactive zooming. See example in the script documentation.




Padding

Padding in [px] gives a margin to the chart.

Spacing

Spacing also in [px] denotes the space between base and deviation chart.

Category Axis

Activate the Checkbox to show the category axis. Size defines the thickness of the axis in [px]. With Category Width the width can be defined as Fix in [px] or automatically set with Auto. The parameter Element Offset determines the shift of elements on the Category Axis. Using the toggle button %/abs allows you to set the value in percent or absolute in [px]. Use negative values for a shift in the opposite direction.

Data Types in Axis

If the Checkbox is activated, Data Types of the first Data Series are shown in the axes as long as the Size is at least 3 [px].I

Suppress Zero Labels

If the Checkbox is activated, the labels of zero values are hidden – both in the Base Chart and the deviation charts.

Helper Tab

Series Labels

Activate the Checkboxes to show the data label on the Data Series.

Axis Labels

Activate the Checkboxes to show the legend at the axes.

Highlight

This function enables you to highlight the absolute or percentage difference between two elements. Activate the Checkbox and set an index for elements where the highlighting should start and end. Choose between a Single highlighting on the side and the highlighting of Multiple elements within the graph. If you select Single, the first element of the list is displayed, and all other elements are ignored. You can also choose whether the absolute and/or percentage values should be displayed.

Value Axis

Activate this Checkbox to show value axes and help lines according to the interval.

Separators

You have the option to set so-called Separators in the chart. These can be set automatically in case of changed Data Types or Categories, or they can be set Manually – according to the selected toggle button. Source Row determines the category row and Series the Data Series according to which Data Type the Separators are shown. Furthermore, you can define the Length, Thickness and Color of the Separators in [px].

Scaling Helper

Activate the appearance – line or area – and the position of the Scaling Helper at this point. Retrieve Value proposes valid values!

Info Tab

Here you will find the version number of our graphomate charts as well as a link where you may report bugs or propose wishes for new features. A list of all open-source libraries that we used can be found under Credits.


  • No labels