Databases Reference
In-Depth Information
Presentation
The
Presentation
tab offers options to change how the data is presented within the
chart. Useful options are under the
Line/Symbol Settings
section; with these options
we can change the
Line Width
option of the chart as well as the size of the symbols
(as we saw when we added the dots in the previous chart).
For charts that have many values on the X-axis, a useful option is the
Chart Scrolling
option. By checking the
Enable X-Axis Scrollbar
checkbox and setting a value for
the
When Number of Items Exceeds
parameter, a scrollbar is added to the chart
whenever the number of values on the X-axis exceeds the specified amount.
Arguably the most useful option in this tab, however, is found under the
Reference
Lines
section. This option can be used to integrate additional, straight lines to the
line chart. A practical example would be to add a target reference to compare each
data point to a predefined objective.
By clicking on the
Add
button, the
Reference Lines
dialog opens. Here we can set
an expression for the reference line, set its label, and change some other settings with
regard to formatting. The following screenshot shows an example of a static 900,000
flights target line, but of course a dynamic target could also be used if it is included
in the data model:
Combo Chart
Though it sounds fancy, the Combo Chart is nothing more than a combination of
the bar and line charts that we used earlier. It brings together all the properties of
both charts.