Description
- Start File
- For this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also build a pie chart sheet to graph the proportion that each category contributes to total revenue.
[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6]
File Needed: ClassicGardens-03.xlsx (Available from the Start File link.) !!
Completed Project File Name: [your name]-ClassicGardens-03.xlsx
Skills Covered in This Project
Create a chart object.
Size and position a chart object.
Edit and format chart elements.
Edit the source data for a chart.
Build a pie chart sheet.
Use texture as fill.
Add and format data labels in a chart. - Select the pie shape and add data labels to display in the center of each slice.
NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.
Explanation & Answer
Attached. Please let me know if you have any questions or need revisions.
Revenue by Category
$32,249
$3,642
$86,454
Lawn Maintenance
Tree & Shrubbery
$46,716
$71,682
Patio and Furniture
Fountains and Irrigation
Design Consulting
Cla...