![Page 1: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/1.jpg)
DAY 8:
EXCEL CHAPTER 4
Michael DeMicco
September 16, 2013
1
![Page 2: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/2.jpg)
WHAT DID WE DO LAST CLASS?
• Assigned Homework 2
• Financial Functions
– PMT/IPMT/PPMT
• Open Lab time for HW1/MyITLab
2
![Page 3: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/3.jpg)
PLAN FOR TODAY
3
• Charts
– Types
– Creation
– Design
– Formatting
– Trendlines
![Page 4: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/4.jpg)
HOMEWORK 1
• Section 19 – 32/47 Submitted
• Section 21 – 34/46 Submitted
• Plan to finish grading (and post) later
tonight.
4
![Page 5: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/5.jpg)
UPCOMING DUE DATES
• MyITLab Lesson B due TONIGHT by
11:59PM
• Microsoft Excel Assignment 2 due this
Friday September 20th by 11:59PM
• Microsoft Excel Assignment 3 due next
Friday September 27th by 11:59PM
5
![Page 6: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/6.jpg)
CHARTS
• Why / what do we use charts for?
– A chart is a visual summary representation of data...
– Charts allow us to quickly look at a large amount of data in an easy to read/understand format
– Charts can allow us to quickly compare two or more data sets
– Chart can show us past/current trends and allow us to project future trends
6
![Page 7: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/7.jpg)
CHARTS
• 6 Main Types of Charts
– Column
– Line
– Pie
– Bar
– Area
– Scatter
7
![Page 8: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/8.jpg)
COLUMN
• A column chart displays data vertically,
with each data series forming a column
8
![Page 9: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/9.jpg)
CLUSTERED COLUMN
9
![Page 10: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/10.jpg)
STACKED COLUMN
10
![Page 11: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/11.jpg)
LINE
• This type of chart uses a line to connect data points in order to show
trends over a period of time. The X axis (Category axis) typically displays
time units, and the Y axis (Value axis) displays values for each point.
11
![Page 12: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/12.jpg)
PIE
• This type of chart plots a single data series where each
point represents a portion of the total of the series
12
![Page 13: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/13.jpg)
BAR
• This type of chart compares values across
categories using horizontal bars.
13
![Page 14: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/14.jpg)
AREA
• This type of chart emphasizes the magnitude of changes
over time by filling in the space between lines with a
color.
14
![Page 15: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/15.jpg)
SCATTER
• This type of chart shows a relationship between two
variables.
15
![Page 16: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/16.jpg)
CHARTS
• 5 More Specialized Types of Charts
– Stock
– Surface
– Doughnut
– Bubble
– Radar
16
![Page 17: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/17.jpg)
STOCK
• This type of chart shows the high, low, opening, and
closing prices for individual stocks over time.
17
![Page 18: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/18.jpg)
SURFACE
• This type of chart displays trends using two dimensions on a
continuous curve.
18
![Page 19: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/19.jpg)
DOUGHNUT
• This type of chart displays values as percentages of the
whole, but may contain more than one data series.
19
![Page 20: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/20.jpg)
BUBBLE
• This type of chart shows relationships
among three values by using bubbles.
20
![Page 21: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/21.jpg)
RADAR
• This type of chart compares aggregate values of three or
more variables represented on axes starting from the
same point.
21
![Page 22: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/22.jpg)
NEXT CLASS
• Assign Homework 3
• Go over Homework 1
• Chapter 5/6 Content
– PivotTables and PivotCharts
• Open Lab time?
22
![Page 23: DAY 8: EXCEL CHAPTER 4 · DAY 8: EXCEL CHAPTER 4 Michael DeMicco michael.demicco@mail.wvu.edu September 16, 2013 1](https://reader033.vdocuments.us/reader033/viewer/2022051511/601ec5191be49851dd7e6bd3/html5/thumbnails/23.jpg)