Premiere Movie Source
You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for November 2016 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Open the downloaded Excel file namedexploring_e03_grader_h1.xlsx.
Set chart filters to remove the Category Totals and the Weekly Totals.
Position and size the chart to fill the range A18:K37.
Change the row and column orientation so that the weeks appear in the category axis and the genres appear in the legend.
Add a value axis title and type Number of Downloads. Apply Black, Text 1 font color to the value axis title.
Move the legend to the right side of the chart and drag the bottom of the chart area down to cover row 37, if necessary.
Select the Drama data series and add data labels in the Outside End position. Add a default Gradient fill to the data labels.
Click cell G5 and insert Line Sparklines for the weekly data for each category and the weekly totals, but do not include the category totals for the data range. The location range should be G5:G15.