Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 1 . Bao wants the chart to compare revenue from movies only. Modify the Stacked Column chart to meet his request and make the
Bao wants the chart to compare revenue from movies only. Modify the Stacked Column chart to meet his request and make the chart more meaningful.
Remove the TV Shows data series from the chart. Add a Data Table with legend keys to the chart. Use Movie Revenue as the chart title, and remove the legend, which repeats information in the data table.
Bao has a text file that describes the types of media the company provides.
Import the data from the file SupportEXCTCScMedia.txt Use the first row as headers, and load the data as a table two columns over from and top aligned to the table for Revenue. Apply the Blue, Table Style Medium table style to the imported table to coordinate with the rest of the worksheet contents. Mac Hint: Import the data as tab delimited text. Format the text as a table using Blue, Table Style Medium
Bao might want to sort and filter the revenue data as well. Format the data under the cell labeled Revenue" as a table with headers and using the Blue, Table Style Medium table style.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started