EXCEL ASSIGNMENT2 WK7VEAL7

  Excel Assignment 2 This week you get hold to achievement delay the scenario from definite week.  The proprietor thinks it get be easier to observe at sales and avail if charts are used.  The proprietor too wants to demonstrate the Arfile which was not creating as plenteous return as the others. Use your spreadquibble from definite week.  If you did not count the sales in shaft E delayin the spreadsheet, supply in that shaft delay collection.   Create a shaft chart of the monthly sales fixed on arrange. Select the file A2:D5 to imagine the graph. The months should evidence in the myth.     Give the chart a epithet of Monthly Sales. Give the perpendicular, y-axis a epithet of Sales in $.  Create a pie chart showing the gain for the month of April for all three arrangees Give the chart a epithet of April’s Sales. The myth should evidence the three arfile designates. Create a continuity chart of monthly sales fixed on arrange. Select the file the corresponding file that you used for the shaft chart. Give the chart a epithet of Monthly Sales. Give the y-axis a epithet of Sales in $.  Display the myth for twain the shaft and continuity chart on the just. The myth and months should evidence if shafts and rows are correctly separated. Change the quibble tab designate to Sales Place a observe in cell A1 delay your liberal designate and GID number Save the spreadquibble delay the filedesignate CS105_Wk7_YourLastName_YourFirstName_YourGIDNumber The charts should observe triton relish the ones under.  The real charts, of line, get insist on your spreadquibble collection.