On the AdvertisingCosts worksheet, create a 3-D Pie chart of the amenities and their six-month totals in the range A16:B22. Reposition the chart so the top left corner of the chart is in cell C14.
Advertising Expenses | |||||||
Monthly Data | |||||||
Amenities | January | February | March | April | May | June | |
Spa | $ 3,200 | $ 3,500 | $ 3,000 | $ 3,200 | $ 2,700 | $ 2,100 | |
Exercise Facility | $ 2,000 | $ 2,500 | $ 2,000 | $ 1,800 | $ 1,500 | $ 2,000 | |
Golf | $ 4,500 | $ 5,000 | $ 5,000 | $ 4,800 | $ 5,200 | $ 3,000 | |
Banquet Facilities | $ 7,000 | $ 8,000 | $ 7,000 | $ 7,250 | $ 8,500 | $ 8,700 | |
Technology Facilities | $ 4,000 | $ 3,000 | $ 4,000 | $ 4,500 | $ 4,800 | $ 3,500 | |
Community Events | $ 3,000 | $ 5,000 | $ 4,000 | $ 3,700 | $ 4,200 | $ 3,600 | |
Family Events | $ 2,700 | $ 2,650 | $ 2,000 | $ 3,500 | $ 2,750 | $ 4,200 | |
Total | $ 26,400 | $ 29,650 | $ 27,000 | $ 28,750 | $ 29,650 | $ 27,100 | |
Semi-Annual Summary | |||||||
Amenities | Total | ||||||
Spa | $ 17,700 | ||||||
Exercise Facility | $ 11,800 | ||||||
Golf | $ 27,500 | ||||||
Banquet Facilities | $ 46,450 | ||||||
Technology Facilities | $ 23,800 | ||||||
Community Events | $ 23,500 | ||||||
Family Events | $ 17,800 | ||||||
Total | $ 168,550 |
First step
select the cells A16:B22
same like below picture
Click on Insert Tab
in the charts group select pie
select 3-d pie
chart will be like this
drag and drop the chart on c14
--
all the best
On the AdvertisingCosts worksheet, create a 3-D Pie chart of the amenities and their six-month totals...
A realty company would like to develop a regression model to help set weekly rental rates for beach properties during the summer season. The independent variables for this model will be the size of the property in square feet, the number of bedrooms it has, the number of balthrooms it has, and its age. Use the accompanying data, which are from randomly selected rental properties, to complete parts a through d below EER Click the icon to view the data...