As an analyst for the airline industry, you track the number of passengers at major U. S. airports. One worksheet you created lists the number of total yearly passengers at the top five airports for four years To prepare for an upcoming meeting, you need to create a chart to compare the number of passengers for each airport. In addition, you want to insert sparklines to visually represent trends in passengers at each airport. CASE a. Open e03mlAirports and save it as e03mlAirports LastFirst
b. Create a clustered column chart for the range A4:E9 Position the chart to fit in the range A15:F34
c. Customize the chart style by doing the following Apply Style 8 chart style . Select Color 6 in the Monochromatic section of the Change Colors gallery . Change the fill color of the 2011 data series to White, Background I
d. Enter Passengers by Top U. S. Airports as the chart title.
e. Adjust the value axis by doing the following OVER Change the display units to Millions for the value axis. . Edit the axis title to display MILLIONS OF PASSENGERS
f. Display data labels above the columns for the 2011 data series only .
g. Insert Line sparklines in the range F5:F9 to illustrate the ava to the rnge as pe. This should insert a sparkline to represent yearly data for each airpott
h. Customize the sparklines by doing the follow ings Show the high and low points in each sparklice. . Apply Black, Text 1 color to the high point merker ch s i e. Apply Dark Red color to the low point matker in each sparsine
i. Merge cells in the range A36:F41, wrap text, and then ayply Top Align and Align Lert alignments.
j. Compose a paragraph that analyzes the trends depicted by the airport sperkdines.