Databases Reference
In-Depth Information
After finishing setting the previous configuration, click on
OK
and the chart will be
more readable and will look like the following screenshot:
Change the chart's
Orientation
to
Horizontal
from the
Style
tab of the properties
window so that it's even more readable.
Interactively changing a variable's value
The reason for using a variable to limit the number of dimension values shown in the
chart is to enable the user to dynamically change it as pleased. There are two main
layout objects through which a variable's value can be changed:
• The Input Box object
• The Slider object
We will describe the two of them and their uses.
Using the Input Box object
The Input Box is basically an Excel-like cell on which the user enters values. An
Input Box can hold any number of variables, each one with its own associated cell.
To describe how it is used, click on an empty space of the sheet workspace and, from
the
New Sheet Object
section, select
Input Box...
.
The
New Input Box
dialog window will appear and the
General
tab will initially be
active. From the
Title
field, we can assign a display text to be placed on the object's
caption bar. Type
Enter number of top values
into this field.
