Databases Reference
In-Depth Information
When we look at this chart, we notice that it's quite hard to read. The numbers are
really large, all those zeroes occupy a lot of space. Besides that, the title text and
caption both say the same thing and do not reference the second expression in
the chart.
We should also note that the corporate colors have been
correctly assigned, since the default color map in place
was defined in the previous chapter.
Let's correct these issues by changing the following settings in the
Properties
dialog:
1.
On the
General
tab, set the
Window Title
field to
# of Passengers/
Available Seats (x 1 million) by Flight Type
. Next, uncheck the
Show Title in Chart
checkbox.
2.
On the
Expressions
tab, select the
# of Passengers
expression and tick the
Values on Data Points
checkbox. Next, highlight
# of Available Seats
and
also check the
Values on Data Points
checkbox. Modify both expressions'
definition by dividing the result by one million. The
expressions will now be:
Sum ([# Transported Passengers]) / 1000000
Sum ([# Available Seats]) / 1000000
3.
On the
Style
tab, change the
Orientation
to horizontal (right icon).
4.
On the
Presentation
tab, set the
legend's font format
to
Tahoma
, with
a
Regular
Font Style
, and with the
Size
set to
8
by first clicking on the
Settings
button, and then clicking on the
Font
button in the
Legend
Settings
dialog window.
5.
On the
Axes
tab, under
Expression Axes
, check the
Show Grid
checkbox.
Change the
Font
format for both
Expression Axis
and
Dimension Axis
to
Tahoma
, with a
Regular
Font Style
, and with the
Size
set to
8
using their
respective
Font
buttons.
6.
On the
Number
tab, hold down the
Shift
key and select
# of Passengers
and
# of Available Seats
from the list of
Expressions
. Next, select
Fixed to
under
Number Format Settings
and set the
Decimals
field to
1
.
7.
On the
Layout
tab, uncheck the
Use Borders
option.
8.
Click on
OK
to close the
Chart Properties
window.