question archive To compare the quarterly sales of each region visually, select the range that represents the 6 sales figures for the four quarters , including the quarter names and each region - do not include any totals in the range
To compare the quarterly sales of each region visually, select the range that represents the 6 sales figures for the four quarters , including the quarter names and each region - do not include any totals in the range
Subject:Mechanical EngineeringPrice: Bought3
To compare the quarterly sales of each region visually, select the range that represents the 6 sales figures for the four quarters , including the quarter names and each region - do not include any totals in the range . With this data selected , by using the Recommended Charts command , insert a Clustered Column chart with the regions as the category axis and the Quarters as the legend 13 Apply Chart Style 8. Change the colors by applying the third row of colors under Colorful 6 Position the upper middle sizing handle of the chart on the line between column D and column E and just below row 9. 14 Change the Chart Title to Regional Sales to Fitness Clubs 4 15 Deselect the chart . Change the page orientation to Landscape . Center the worksheet 4 horizontally on the page , and then insert a Footer with the File Name in the left section 16 Show the document properties. As the Tags, type fitness clubs , regional sales In the Subject 2 box , type your course name and section number . Be sure your name displays as the Author 17 Save and close the workbook , and then submit for grading 0 Total Points 100
