Challenge Project 3-8

For this project, you build a worksheet that displays data from two departments in a supermarket. Each department has subgroups, and each subgroup lists items. From this hierarchical data, you create and format a sunburst chart.

[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.7]

File Needed: None

Completed Project File Name: [your initials] Excel 3-8.xlsx

Create a new workbook and save it as [your initials] Excel 3-8. Modify your workbook according to the following guidelines:

• Type Grocery in cell A2 as a general category in the supermarket. In cell B2, type Coffee as a product subgroup. In cells C2:C5, type Ground, Whole Bean, K-Cup and Instant as further divisions of the coffee subgroup.
• Type Pasta in cell B6. In cells C6:C9, type the names of four types of pasta (spaghetti, rotini, vermicelli, bucatini, rigatoni, etc.)
• Select cell A10 and type Produce. In cell B10, type Fruit. In cells C10:C13, type the names of four different fruits.
• Complete a vegetable subgroup for the Produce category starting in row 14.
• Type a value for each item in column D to represent the number of transactions per day that included that item.
• Select the data and create a Sunburst hierarchy chart on its own sheet.
• Edit the chart title placeholder and apply a chart style.
• Determine how to format the outer ring items and apply fill colors to differentiate each item in the Fruit group.