Charting Sales Data Excel Exercise

/in /by

Get perfect grades by consistently using our affordable writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Following the directions below create the below charts. Note to match each chart exactly, including the chart styles, and axis bounds.

  1. Open the file named SC4 Data and then Save As [name]SC4 Sales. (example: Dobbs SC4 Sales)
  2. From the Revenue & Profit Margin sheet, create the below Combination Chart.
  3. Move the chart to a new sheet. Name the sheet Combo.
  4. Save your work.
Solution Screenshot
Figure 4.36 Combination Chart

TASK 2 QUARTERLY PRODUCTION DATA

Create the below Pie Chart showing how many locations will be producing products in the North, South, East and West Regions.

  1. From the Products sheet create the below chart.
  2. Move the chart to a new sheet. Name the sheet Doughnut.
  3. Save your work.
Screenshot of the Doughnut Chart
Figure 4.37 Doughnut Chart

TASK 3 SALES PIPELINE

Create the below Funnel Chart to provide our sales team a visual snapshot of the company’s sales process, outlining deals that are expected to close within the month.

  1. From the Sales sheet, create the below Funnel Chart.
  2. Note to leave the chart embedded in the sheet. Resize, and move the chart accordingly.
  3. Check the spelling on all of the worksheets and make any necessary changes. Save your work and submit as directed by your instructor.

PLEASE SUBMIT THE SPEADSHEET BACK AS AN ATTACHMENT.

Screenshot of the Funnel Chart
Figure 4.38 Funnel Chart

Have your paper completed by a writing expert today and enjoy posting excellent grades. Place your order in a very easy process. It will take you less than 5 minutes. Click one of the buttons below.


Order a Similar Paper Order a Different Paper