4. Objects
4.15 Inserting Chart Objects
4.15.5 Chart Properties Bar/Line Charts
For the chart type "Bar/Ribbon" and "Line/Symbol" you have the following options. Depending on the chart type, there are two or three data axes.
Using the tabs you can switch from one axis to another. Select the presentation (Cylinder, Bar, Pyramid, Ribbon, Line, Symbols, Line+Symbols, Octaeder, Cone) in the property "Presentation" on the tab
"Value Axis".
Options for category and series axis
If you chose to have a three axis chart, both axes are available (as x and y-axis). Only the category axis is needed (as x axis) for two axis charts. You have the same options for both axes:
See also Chapter "Common Object Properties".
Property Description Value Description
Coordinate
Value Select the data source for the row, e.g.
"Name" for people, "Month" for date Formula Formula dialog
values, and so on.
Sort
Coordinates Sets wether the data should be sorted
(alpha numeric or numeric). True False
The designer has no access to the "real"
data which will appear in your chart when printing. In order to have a picture of how your chart is going to look like, you can set the number of values to appear in the designer here.
Numbe
r Formula
dialog
Filter Allows to filter the diagram data. Only the records matching the condition will be used for the chart data. If you leave the default setting "True" the chart will display all values.
Axis label Select a text for your axis label here. Formula Formula dialog Rotation Rotation Angle in degrees. Numbe
r Formula
dialog Coordinate
Label Select the text which should be used to
label the legend. Formula Formula
dialog Rotation Rotation Angle in degrees. Numbe
r Formula
dialog Fixed
Fontsize Sets wether the font size should be fixed. If not, the font size will be decreased in order to prevent text from overlapping.
Legend Select the position of the legend. If you Select "at chart" the values are given directly at the axis. Otherwise, a legend will be added on the left, right, bottom or top of the chart.
Options for the value axis
On the Value Axis tab, you set the Data, Appearance and Axis Label of the Bar Chart or Line Chart.
Primary Axis / Secondary Axis: A second value axis is supported. Enable the secondary axis on the tab "Diagram". Use the Combobox to switch between the properties of the axes.
See also Chapter "Common Object Properties".
Property Description Value Description
Coordinate
Value Select the data source for the value axis,
e.g. "Value", "Price" etc. Formula Formula dialog
Axis scale Axis scale type. 0
1
2
None (linear) Logarithmic, Base 10 (decadicly) Logarithmic, Base 2
Formula (binary)
You can limit the shown data range in order to e.g. regard huge divergences within the values. If your values have high peaks, you can cut them of by setting a max limit. If you leave the default setting "No" the chart will display all values.
Threshold Maximal Axis Value. Numbe
r Formula
dialog Minimum
Value Automatic
You can limit the shown data range in order to e.g. regard huge divergences within the values. If your values have low peaks, you can cut them of by setting a Minimum Value. If you leave the default setting "No" the chart will display all values.
Threshold Minimal Axis Value. Numbe
r Formula
dialog Presentation Visual presentation. Depending on
selected type and subtype diferent types of representation are available:
Pie:
-Bar Simple, Clustered:1, 2, 3, 8, 9 Bar Multi Row:1, 2, 3, 4, 8, 9
Width Bar or Line width. Numbe
r Formula
dialog Label on
objects Sets the text to display on the objects. 0 1 Content The formula of the
elements label, e.g.
LL.ChartObject.AxisCoordi nate
Formula Formula dialog
Coordinate Sets whether coordinate lines should be True Yes
dialog Zebra Mode Sets whether a zebra pattern should be
drawn in the chart background. Transparent
Pattern/Block
Axis Label Axis label text. Formula Formula
dialog Rotation Rotation of the axis label
text in degrees. Numbe
r Formula
dialog Coordinate
Label Coordinate label resp. legend text, e.g.
LL.ChartObject.AxisCoordinate. Formula Formula dialog Rotation Rotation of the Coordinate
Label text in degrees. Numbe
r Formula
dialog Fixed
Fontsize Sets wether the font size should be fixed. If not, the font size will be decreased in order to prevent text from overlapping.
Coordinate Tick Distance (Ticks). True False Legend Select the position of the legend. If you
Select "at chart" the values are given directly at the axis. Otherwise, a legend will be added on the left, right, bottom or top of the chart.
Keine an Achse
Number of
Ticks The number of sub-ticks between two
major coordinate ticks. Numbe
r Formula
dialog
Define rows
The Series Axis (y-axis) for a three dimensional chart has the additional possibility to select the values not just by formula but also by rows. Modify via the Combobox located above the properties list for the entry "Use rows as data source". The property "Row Definitions" can be used to modify the properties of the axis. Open the dialog "Row definitions" and define the individual rows (e.g. Measured Value/Target/Actual values). It is possible to define properties for each row and then move it to the section orientation menu.
Diagram-Options for the chart object
On the Diagram tab, you set the optional secondary axis and Appearance of the Bar Chart or Line Chart..
See also Chapter "Common Object Properties".
Property Description Value Description
Secondary
Axis Enables a secondary axis. Use the Combobox on the tab "Value Axis" to switch between the properties of the axis.
True False Formula
Yes No Formula dialog Axis
Assignment Determines the value axis for the value. 0
1 Formula
Primary Secondary Formula dialog Orientation Orientation of the chart, e.g. a
horizontal 2D-Bar-Diagram. Left to right
Bottom to top Illuminated Sets whether the chart should be True Yes
illuminated. False
Formula No Formula dialog Color Mode Sets the axis determining the color (if
applicable). 0
Color Sets whether the background should
be transparent or colored. Transparent
Pattern/Block Color
Isotropic Sets if both axes use the same units
(x-and y-axis). True Perspective Select the level of perspective for your
object here. 0
Angle The rotation angle of the x axis upward in degrees, maximally 90°
(perpendicular).
You may also set these angle using the rotation buttons which appear when the chart is selected on the workspace.
Numbe
r Formula
dialog
Y Axis Rotation
Angle The rotation angle around the center against the clockwise direction in degrees.
You may also set these angle using the rotation buttons which appear when the chart is selected on the workspace.
Numbe
r Formula
dialog