Charts 1 (submit attempt 1)

.xlsx

School

Binghamton University *

*We aren’t endorsed by this school

Course

111

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

18

Uploaded by SuperHumanAlligator383

Charts Key Terms: Windows/Macs Shortcut Keys: N/A Additional Resources: Charts 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
Sparklines 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.
81583
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 Reel Homes Cla rk And Lovell Buil ders Tra di tion Homes Ted G inde s Constr uc tion Neyz ari Homes Lindsay Builder s Dimple Const ruc tion SHC Lan d Con sulta nts Cor p. JKU S Inc. Tik i Ho me Impro vement Cedar R idge Bui lders San dy Spring Classi c Homes Design/Build Coloni al Desi $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000 $110,000 2012-2014 Yearly Expenses P 2012 2013 2014
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 f 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 ex "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" und 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. s uild Inc . Desi gn & Build Compas s Homes Elm Company Rbc Homes Fran kl in Reno vatio ns Classic Homes Of Virginia Per Firm
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help