Grader - Instructions For Excel 2019 Project Exp19_Excel_Ch0 ✓ Solved

```html

Grader - Instructions Excel 2019 Project Exp19_Excel_Ch03_CapAssessment_Movies

Project Description: 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 April 2021 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.

Steps to Perform:

  1. Start Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.
  2. Create a pie chart to show the percentage each category contributes to the monthly movie downloads. Select the ranges A5:A10 and F5:F10. Move it to a chart sheet named April Pie Chart. The chart needs the title "April 2021 Downloads by Genre", bold, 18 pt font size, and Black, Text 1 font color. Add category and percentage data labels in the Inside End position. Remove value data labels and the legend.
  3. Focus on comedy movies by exploding that slice by 7% and applying Dark Red fill color. Add Alt Text: "The pie chart shows the percentage of downloads by genre for April 2021."
  4. Create a combo chart to depict the monthly totals and percentages by category. Select the ranges A4:A10 and F4:G10, and create a Clustered Column – Line on Secondary Axis combo chart. Position the chart below the data source, cut it, and paste it in cell A13.
  5. Change the height to 3.5" and the width to 6". Change the combo chart title to "April 2021 Downloads" in Black, Text 1 font color. Add primary and secondary value axis titles.
  6. Format the secondary value axis to display whole percentages. Remove the legend and apply Light Gradient – Accent 1 gradient fill color for the plot area. Add Alt Text: "The combo chart shows the number and percentage of downloads by genre for April 2021."
  7. Insert Line Sparklines in range H5:H11 for weekly totals, applying Black, Sparkline Style Dark #. Show high points and change their marker color to Red.
  8. Create a stacked bar chart for weekly downloads from range A4:E10. Move the chart to a new sheet named "Weekly Downloads". Apply Style 8 chart style and title it "April 2021 Weekly Downloads by Genre".
  9. Adjust the maximum bounds for the value axis and format the category axis. Add primary minor vertical gridlines, and include Alt Text: "The stacked bar chart shows downloads by each week for each genre."
  10. Insert a footer with "Exploring Series" on the left, the sheet name code in the center, and the file name code on the right on all sheets. Change to Normal view. Save and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx. Exit Excel.

Submit the file as directed.

Paper For Above Instructions

The task at hand involves creating various charts and visual representations of movie download data from April 2021 by genre at Premiere Movie Source. To accomplish this, we will use Microsoft Excel 2019 to compile and visualize the data effectively, which is crucial for making informed business decisions. This report outlines the step-by-step procedures involved in creating these charts, ensuring that accessibility and clarity are prioritized. Each visualization serves a specific purpose, enhancing the overall understanding of sales trends based on the genre of movies.

Creating a Pie Chart

The first chart we will create is a pie chart that showcases the percentage of each genre's contributions to the total movie downloads. This will be done by selecting the data ranges A5:A10 (genres) and F5:F10 (download numbers) from the Excel workbook. Once selected, we will insert a pie chart and transfer it to a new chart sheet named “April Pie Chart”. The title "April 2021 Downloads by Genre" should be applied in a bold 18 pt font size with a black text color to ensure it’s easily readable.

To provide additional clarity, we will include category and percentage data labels positioned within the pie segments. It’s important to remove value data labels and legends for minimal clutter and focus on the essential information. To emphasize comedy films, we will explode that segment by 7% and fill it with a dark red color for differentiation. Additionally, we will make our charts accessible by adding alternative text (Alt Text), which states: "The pie chart shows the percentage of downloads by genre for April 2021."

Creating a Combo Chart

Next, we will create a combo chart that displays the monthly totals and category percentages. We again select the relevant data ranges A4:A10 (genres) and F4:G10 (totals and percentages) from the data sheet to generate a Clustered Column – Line on Secondary Axis combo chart. After positioning this chart below the data source, we will adjust its dimensions to a height of 3.5 inches and a width of 6 inches for an ideal fit.

The chart title, now changed to "April 2021 Downloads", will also be formatted with a black text color. Importantly, we will add titles to both the primary and secondary axes: "Number of Downloads" and "Percentage of Monthly Downloads", respectively, which will clarify the chart’s data representation further. Removing the legend and configuring the secondary axis to display whole percentages will refine the chart, and we’ll enrich the visual appeal with a Light Gradient – Accent 1 fill for the plot area. We’ll also include Alt Text to ensure accessibility compliance: "The combo chart shows the number and percentage of downloads by genre for April 2021."

Inserting Sparklines

For an at-a-glance representation of weekly downloads by genre, we will insert Line Sparklines. Selecting the range B5:E11, we will place these sparklines in the corresponding range H5:H11 with the darker sparkline style for clarity. The display of markers will be enabled to indicate specific points, while the high points will be highlighted in red to ensure they stand out against the rest.

Creating a Stacked Bar Chart

Lastly, a stacked bar chart will be created to visualize weekly downloads. Selecting the data in A4:E10, we will create and place this chart into a new sheet titled “Weekly Downloads”. The chart will be styled according to Style 8, with a title "April 2021 Weekly Downloads by Genre". Adjustments to font sizes will ensure all text is legible.

The maximum bounds for the value axis should be set to 9000, with major units set at 500. We also need to adjust the category labels to be in reverse order, as this displays the data aligned with how we want it categorized logically. Adding primary minor vertical gridlines will enhance visibility while ensuring that alternate text, "The stacked bar chart shows downloads by each week for each genre," is included for accessibility.

Final Steps

Lastly, a footer will be included across all sheets with “Exploring Series” on the left, the sheet name in the center, and the file name on the right. After these adjustments, we will change to Normal view, save the workbook titled Exp19_Excel_Ch03_CapAssessment_Movies.xlsx, and exit Excel.

References

  • Microsoft Corporation. (2021). Excel 2019 Help & Learning. Retrieved from https://support.microsoft.com/en-us/excel
  • Pearson Education. (2018). Excel 2019: The Missing Manual.
  • Walkenbach, J. (2018). Excel 2019 Power Programming with VBA.
  • Lee, C. (2020). Data Visualization with Excel Charts and Graphs.
  • Beran, R. (2019). The Visual Guide to Excel 2019.
  • Griffiths, D. (2021). Excel 2019 for Dummies.
  • Chamberlain, L. (2021). Excel Data Analysis: Your visual blueprint for creating and presenting data, charts, and graphs.
  • Cutts, B. (2018). Pro Excel 2019 Development.
  • Fitzgerald, D. (2020). Excel 2019 Essentials.
  • Kennedy, K. (2019). Excel 2019 Advanced: Beginner’s to advanced.

```

Related Assignments