Charts 1 (submit attempt 1)
.xlsx
keyboard_arrow_up
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