Question: 25 Create a 2-D Line chart that compares the stagnant profits to the estimated profits for each of 9 the seven years. Include the year

 25 Create a 2-D Line chart that compares the stagnant profits

25 Create a 2-D Line chart that compares the stagnant profits to the estimated profits for each of 9 the seven years. Include the year labels in the chart data. Position the chart to fit within the shaded area of G9:N20. Make the following changes: Apply Style 13 to the chart Move the Legend to the bottom Add a primary vertical axis title of Annual Profits Edit the Chart Title to read Estimated and Stagnant Profit Trajectories 26 Change the fill color of all uncertain variables (B10 and H4:N4) to Green, Accent 6. 2 27 Change the fill color of all input variables (B2:B3 and B6) to Orange, Accent 2. 2 28 Change the fill color of all decision variables (B7 and E8) to Blue, Accent 5. 2 29 Insert a comment into the output cell of H7 that reads: Output - Total additional profits 2 earned post renovation. Must be > than total cost of loan. Be sure to include the period at the end and remove any name or initials that may appear at the start of the comment. 30 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as 0 directed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!