Chat with us, powered by LiveChat Using your forecast from the previous assignment create the following charts - EssayAbode

Using your forecast from the previous assignment create the following charts

 Chart Assignment 

Using your forecast from the previous assignment create the following charts:
• A column chart for Occupancy % for January 1st -7th
o Chart Title should be “January Occupancy 1st-7th”
o Category x axis should be “Date”
o Category y axis should be “Occupancy %”
o Remove Legend (if applicable)
o Include the “Value” as a data label 
o Save the chart as a new sheet called “Chart 1”
• A pie chart comparing Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue totals for Jan 3rd.
o Chart Title should be Revenue Sources
o Category Labels should be Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue.
o Include “Value” & “Percentage” as data labels 
o Save the chart as a new sheet called “Chart 2”
• A line chart comparing Transient Room Rate and Group Room Rate for Jan 1st–7th.
o Chart Title should be “Room Rate Analysis”
o Category x axis should be “Date”
o Category y axis should be “Rate”
o Change Series 1 label to “Transient”
o Change Series 2 label to “Group”
o Category x axis labels should be 1 thru 7
o Include “Value” as a data label
o Save chart as a new sheet called “Chart 3”

Save your file as “Chartsfirstlastname” 

 

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing