Question: To visually analyze each question's rating, insert an Area chart using source cell range B 2 3 :L 2 4 . Add the following elements

To visually analyze each question's rating, insert an Area chart using source cell range
B23:L24. Add the following elements to the Area chart:
-Change the chart color to Monochromatic Palette 4.
-Change the chart style to Style 4.
-Move the upper-left corner of the Area chart to cell B26(be sure the upper-left border of cell B26 is visible).
Add a vertical axis title named Guest Rating
Add a horizontal axis title named Guest Number
Change the vertical axis Bounds maximum to 5 and the major Units to 1 Test the criteria area and chart by changing the value in cell A24 to 01H

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 General Management Questions!