Charts 1

Charts Key Terms: Windows/Macs Shortcut Keys: N/A Additional Resources: Charts Sparklines Summary : Charts are utilized to provide visual representation of data sets. on how you would like to display your data. In order to access the chart de adjust your data series through the "Select Data" command in the Chart De of a selected dataset. Chart - A visual graph that displays selected data to show trends and patter Chart Elements - Different properties that make up a chart. Some propertie Format Axis Task Pane - Double click your chart or a chart element to acces Sparkline - A miniature chart that displays the trends of a selected set of da Link 1 Link 1

s & Sparklines . You can choose between multiple chart types including line, column or pie depending esign or format tabs, you need to click on a created chart. You can also add, delete or esign tab. Sparklines are miniature graphs that quickly display the trends and patterns rns. es include titles, axes, legends and trendlines. ss this pane. Provides more chart options such as changing the axis scale or formatting. ata. OR

Company Kind of Business 2012 Reel Homes Motor Vehicle and Motor Vehicle Parts and Supplies $ 69,124 Clark And Lovell Builders Furniture and Home Furnishings $ 19,079 Tradition Homes Lumber & Other Construction Materials $ 23,214 Ted Gindes Construction Professional and Comercial Equipment and Supplies $ 97,650 Neyzari Homes Computer and Computer Peripheral Equipment and Software $ 33,132 Lindsay Builders Metals and Minerals, ex. Petroleum $ 20,788 Dimple Construction Electrical Goods $ 81,145 SHC Land Consultants Corp.Hardware, and Plumbing and Heating Equipment and Supplies $ 29,404 JKUS Inc. Machinery, Equipment and Supplies $ 93,868 Tiki Home Improvement Miscellaneous Durable Goods $ 41,191 Cedar Ridge Builders Paper and Paper Products $ 21,964 Sandy Spring Classic HomesDrugs and Druggists' Sundries $ 72,485 Design/Build Inc. Apparel, Piece Goods, and Notions $ 35,391 Colonial Design & Build Groceries and Related Products $ 95,927 Compass Homes Farm Product Raw Materials $ 11,192 Elm Company Chemicals and Allied Products $ 31,288 Rbc Homes Petroleum and Petroleum Products $ 29,778 Franklin Renovations Beer, Wine, and Distilled Alcoholic Beverages $ 25,938 Classic Homes Of Virginia Miscellaneous Nondurable Goods $ 39,646 10000 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 $69,124 $19,079 $23,214 $97,650 $33,132 $20,788 $81,145 $29,404 $93,868 $41,191 $21,964 $72,485 $35,391 $95,927 $11,192 $31,288 $29,778 $25,938 $70,773 $19,899 $24,518 $98,405 $33,289 $21,226 $84,895 $30,347 $96,376 $40,511 $22,283 $74,247 $37,013 $97,843 $11,644 $31,613 $30,613 $26,652 $74,388 $20,943 $26,019 $101,277 $33,258 $21,566 $88,877 $32,071 $102,805 $40,905 $22,646 $75,211 $38,834 $101,034 $11,736 $33,526 $32,064 $28,021 2012-2014 Yearly Expenses Per Firm 2012 2013 2014 Axis Title Axis Title

2013 2014 $ 70,773 $ 74,388 $ 19,899 $ 20,943 $ 24,518 $ 26,019 $ 98,405 $ 101,277 $ 33,289 $ 33,258 $ 21,226 $ 21,566 $ 84,895 $ 88,877 $ 30,347 $ 32,071 $ 96,376 $ 102,805 $ 40,511 $ 40,905 $ 22,283 $ 22,646 $ 74,247 $ 75,211 $ 37,013 $ 38,834 $ 97,843 $ 101,034 $ 11,644 $ 11,736 $ 31,613 $ 33,526 $ 30,613 $ 32,064 $ 26,652 $ 28,021 $ 41,991 $ 40,691 Instructions: 1) A list of company yearly expenses are provided in a table to the left. Create a 2D column chart to portray each companies yearly expenses fo 2012-2014. Note: Each company should have three columns showing each years expenses. 2) Add a Chart Title through the chart elements and label the Chart exa "2012-2014 Yearly Expenses Per Firm". 3) Include a legend key above the chart that shows the year that each column color represents. 4) Change the horizontal axis to include the names of each company so you can see what company each group of columns represent. Note: You can change the horizontal axis by going to "Select Data" unde Chart Design Tab and editing the horizontal axis labels. You will need to the chart first to axis the "Chart Design" tab in the ribbon. 5) Change the Vertical Axes where the minimum bounds is 10,000 and maximum bounds is 110,000.

81333

Company Revenues ($MM) Profit ($MM) Profit as % of Revenues Constellation Brands $ 6,548 $ 1,055 16.1% Coca-Cola $ 41,863 $ 6,527 15.6% Dr. Pepper Snapple Group $ 6,440 $ 847 13.2% Kraft Heinz $ 26,487 $ 3,632 13.7% General Mills $ 16,563 $ 1,697 10.2% Pepsico $ 62,789 $ 6,329 10.1% Hershey $ 7,440 $ 720 9.7% Hormel Foods $ 9,523 $ 890 9.3% J. M. Smucker $ 7,811 $ 689 8.8% Campbell Soup $ 7,961 $ 563 7.1% Mondelez International $ 25,923 $ 1,659 6.4% Kellogg $ 13,014 $ 694 5.3% Land O'Lakes $ 13,233 $ 245 1.9% Dean Foods $ 7,710 $ 120 1.6% Treehouse Foods $ 6,175 $ (229) -3.7% Conagra Brands $ 14,134 $ (677) -4.8% Colgate-Palmolive $ 15,195 $ 2,441 16.1% Procter & Gamble $ 71,726 $ 10,508 14.7% Kimberly-Clark $ 18,202 $ 2,166 11.9% Clorox $ 5,761 $ 648 11.2% Estee Lauder $ 11,262 $ 1,115 9.9% Avon Products $ 5,853 $ (108) -1.8% HRG Group $ 6,403 $ (199) -3.1% Gilead Sciences $ 30,390 $ 13,501 44.4% Amgen $ 22,991 $ 7,722 33.6% Biogen $ 11,449 $ 3,703 32.3% Johnson & Johnson $ 71,890 $ 18,540 25.8% Abbvie $ 25,638 $ 5,953 23.2% Bristol-Myers Squibb $ 19,427 $ 4,457 22.9% Celgene $ 11,229 $ 1,999 17.8% Pfizer $ 52,824 $ 7,215 13.7% Eli Lilly $ 21,222 $ 2,738 12.9% Merck $ 39,807 $ 3,920 9.8% Altria Group $ 19,337 $ 14,239 73.6% Reynolds American $ 12,503 $ 6,073 48.6% Philip Morris International $ 26,685 $ 6,967 26.1%

ng y. . t an t an

81333

2013 2014 2015 2016 2017 $ 160,000 $ 187,807 $ 205,000 $ 228,990 $ 224,900 $ 264,500 $ 305,000 $ 349,000 $ 364,900 $ 365,500 $ 152,000 $ 162,951 $ 179,900 $ 190,000 $ 215,653 $ 149,000 $ 151,700 $ 148,973 $ 154,100 $ 152,000 $ 259,000 $ 299,000 $ 335,000 $ 325,000 $ 375,000 Instructions: 1) The raw table above shows 5 Texas cities and their median housing lis prices between 2010-2017. Create a 2D line chart showing each cities median housing listing between 2010-2017. Note: Excel might group each line by the year instead of the city. You ma need to go to "Select Data" under the Chart Design tab in the ribbon to e your data. There should only be 5 data series (5 line graphs) representing each city. 2) Change the horizontal axis to show the year so that you can see wher the median housing price is for each city at each year. Note: You can change the horizontal axis by going to "Select Data" under the Chart Design Tab and editing the horizontal axis labels. You will need click the chart first to axis the "Chart Design" tab in the ribbon. 3) Add a Chart title through your chart elements and label it exactly "Tex Median Housing Prices". 4) Add a Vertical and Horizontal axis title. The Vertical axis title should be labeled "Listing Price" and the horizontal axis title should be labeled "Ye 5) Add a Legend above the chart. The legend will show us which city represents which line data series.

st ay edit g re r d to xas e ear".