Databases Reference
In-Depth Information
10. On the
Axes
tab, mark the
Show Grid
,
Show Minor Grid
, and
Label Along
Axis
checkboxes under X-axis as well as under the y axis. These options add
a visible grid to the chart as well as place the labels alongside the axes, which
takes less space. Click on
Next
.
11. On the
Colors
tab, enable the
Persistent Colors
checkbox. This setting
ensures that dimensions (in our case carriers) keep the same color even when
the selection changes. Click on
Next
.
12. On the
Number
tab, select all three expressions and set the
Number Format
Settings
option to
Integer
. Enter
x 1 thousand
in the
Thousand Symbol
field,
x 1 million
in the
Million Symbol
field, and
x 1 billion
in the
Billion Symbol
field.
13. Click on
Finish
to apply the settings and close the dialog.
The resulting chart is shown in the following screenshot. The Y-axis shows the
number of transported passengers while the X-axis shows the amount of transported
mail. The bubble size indicates how many flights (departures) have been performed
by each carrier.
We can immediately see there are carriers that only transport mail, such as
United
Parcel Service
, and those that only carry passengers, such as
Southwest Airlines Co
.
In fact, most carriers seem to either do one or the other, not both.
Make a few selections on the
Carrier's Operating Region
listbox and you might
gain some interesting insights. Also notice how the unit of the chart's scale
changes between selections because we set the
Thousand
,
Million
, and
Billion Symbol
fields.