DAY 8:
EXCEL CHAPTER 4
Michael DeMicco
September 16, 2013
1
WHAT DID WE DO LAST CLASS?
• Assigned Homework 2
• Financial Functions
– PMT/IPMT/PPMT
• Open Lab time for HW1/MyITLab
2
PLAN FOR TODAY
3
• Charts
– Types
– Creation
– Design
– Formatting
– Trendlines
HOMEWORK 1
• Section 19 – 32/47 Submitted
• Section 21 – 34/46 Submitted
• Plan to finish grading (and post) later
tonight.
4
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
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
CHARTS
• 6 Main Types of Charts
– Column
– Line
– Pie
– Bar
– Area
– Scatter
7
COLUMN
• A column chart displays data vertically,
with each data series forming a column
8
CLUSTERED COLUMN
9
STACKED COLUMN
10
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
PIE
• This type of chart plots a single data series where each
point represents a portion of the total of the series
12
BAR
• This type of chart compares values across
categories using horizontal bars.
13
AREA
• This type of chart emphasizes the magnitude of changes
over time by filling in the space between lines with a
color.
14
SCATTER
• This type of chart shows a relationship between two
variables.
15
CHARTS
• 5 More Specialized Types of Charts
– Stock
– Surface
– Doughnut
– Bubble
– Radar
16
STOCK
• This type of chart shows the high, low, opening, and
closing prices for individual stocks over time.
17
SURFACE
• This type of chart displays trends using two dimensions on a
continuous curve.
18
DOUGHNUT
• This type of chart displays values as percentages of the
whole, but may contain more than one data series.
19
BUBBLE
• This type of chart shows relationships
among three values by using bubbles.
20
RADAR
• This type of chart compares aggregate values of three or
more variables represented on axes starting from the
same point.
21
NEXT CLASS
• Assign Homework 3
• Go over Homework 1
• Chapter 5/6 Content
– PivotTables and PivotCharts
• Open Lab time?
22