Designer Clothing
This assignment asks you to complete a worksheet and associated charts for a Designer Clothing boutique, and then link these Excel objects to an appropriate memo. Open the partially completed Chapter 3 Mini Case workbook. Compute the sales totals for each individual salesperson as well as the totals for each quarter, Then format the sheet in an attractive fashion(you may want to use auto format options). You have three charts to complete.
Chart one:
A 3D pie chart showing total sales for each Quarter, show percents put this chart on the sales data sheet.
Chart two: create a Columns chart to show the total sales for each sales person. Include an auto shape and text box to add emphasis your chart.
Chart three: Create a stacked columns chart showing total sales for each sales person and show their sales for each quarter.
Next imbed the appropriate data and chart in to the memo