Databases Reference
In-Depth Information
Sheet handling
The design toolbar at the top of the screen contains some
useful commands for dealing with worksheets.
The first icon on the left adds a new sheet. The second and
third icons move the currently active sheet to the left or
the right on the tab row. The last icon is used to open the
properties dialog for the currently active sheet.
The same functionality can also be found under the
Layout
menu. This menu additionally contains the
Remove Sheet
function, which will remove the currently active sheet.
Just as a quick review to keep our focus, the following requirements were defined for
the
Analysis
sheet:
• Trend analysis of the number of flights, enplaned passengers, freight, and
mail through time
• Top 10 routes based on the number of flights, enplaned passengers, freight,
and mail
• The number of passengers versus available seats (Load Factor %) across
flight types
• The relationship between enplaned passengers, mail, and the number
of flights
Adding a new chart
Now that we have a general layout to start from, it is time to add another chart to
the
Analysis
sheet. As you might remember from
Chapter 2
,
Seeing is Believing
, a new
chart can be added by selecting
Layout
|
New Sheet Object
|
Chart
from the menu,
right-clicking on the worksheet and selecting
New Sheet Object
|
Chart
, or clicking
on the
Create Chart
button on the toolbar.