Day 7: Excel chapter 4 - PowerPoint PPT Presentation

1 / 39

  • Uploaded on
  • Presentation posted in: General

“Two roads diverged in a wood, and I took the one less traveled by, and that has made all the difference.  ” –Robert Frost. Day 7: Excel chapter 4. CS 101 September 10th , 2014. Homework #1. Due this Friday 09/12 by midnight 20% penalty for each day late

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Day 7: Excel chapter 4

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Day 7 excel chapter 4

“Two roads diverged in a wood, and I took the one less traveled by, and that has made all the difference. ”–Robert Frost

Day 7 excel chapter 4

Day 7:Excel chapter 4

CS 101

September 10th, 2014

Homework 1

Homework #1

  • Due this Friday 09/12 by midnight

  • 20% penalty for each day late

  • Only accepted through the CS101 website

  • You must set-up your analysis questions tab correctly!

Day 7 excel chapter 4


What is a visual representation of numerical data?


Why use a chart

Why use a chart?

  • “A picture is worth a thousand words”

    Charts often more effectively communicate data

  • Charts can contain enough data to be useful, but not overwhelm people

Chart basics

Chart basics

The four (most common) chart types:

  • Column – compares data vertically

  • Bar – compares data horizontally

  • Line – uses a line to connect data points

  • Pie – shows each data point in proportion to the whole data series

Chart elements

Chart elements

Chart Area

Plot Area

Category Axis(X Axis)

Value Axis

(Y Axis)

Column charts

Column charts

  • Displays data vertically in columns

  • More effective with a limited of number of categories (too many and the columns run together)

    Example: Compare revenue among different cities for one year.

Cluster column chart

Cluster column chart

Clusters of columns side by side for easy comparison.

Stacked column chart

Stacked column chart

Shows the relationship of individual data points to the whole category, one column per category.

100 stacked column chart

100% stacked column chart

Compares the percentage each data point contributes to the total for each category.

3 d column chart


Looks pretty.

Bar charts

Bar charts

  • Displays data horizontally in rows. (bars)

  • Similar to column charts, they can be stacked, clustered, 100% stacked…

Line charts

Line charts

  • Displays lines connecting data points to show trends over equal time periods.

  • The category axis represents time

  • The value axis represents the value

Single data series

Single data series

Multiple data series

Multiple data series

Pie charts

PIE Charts

  • Shows each data point in a proportion to the whole data series.

  • The larger the slice, the larger the percentage.

Basic pie chart

Basic pie chart

Exploded 3d pie

Exploded 3d pie

Stop project time

Stop: Project time

In Class Chart Demo

Chart design

Chart design

Changing the chart type:

  • Select the chart

  • Click the Design tab

  • Click Change Chart Type in the Type group

  • Select the desired type, click OK

Changing adding deleting data series

Changing/Adding/deleting data series

  • Select Chart

  • Design Ribbon

  • Data Group -> Select Data

  • Remove/Add/Delete

Switching rows columns

Switching rows/columns

  • Select Chart

  • Design Ribbon

  • Data Group -> Switch Row/Column

Chart styles

Chart styles

Can be applied to already made charts.

  • Select Chart

  • Design Ribbon

  • Chart Style Group -> Select Style

Embed an excel chart

Embed an Excel chart

  • Insert Ribbon

  • Click Object

  • Create New

  • Microsoft Excel Chart

  • Click OK

  • Replace the Sample Data in Sheet 1

Sample chart

Sample chart

You can also copy paste

You can also, copy/paste

Supplemental content

Supplemental content

Deals with horizontal axes.



Trendlines are useful because they can be used to predict future or past values by extrapolating the lines already plotted on a chart.

Trendline types

Trendline types

  • Linear Trendline

  • Exponential Trendline

  • Linear Forecast Trendline

  • Two Period Average Trendline

Adding trendlines

Adding trendlines

Select Data Series (In this case C grades)

Adding trendlines cont d

Adding trendlines - cont’d

The trendline

The trendline

Predicting the future past with trendlines

Predicting the future/past with trendlines

  • Right-click on the trendline you want to predict the values into the future or past

  • Click on Format Trendline

  • Forecast Group -> Set Periods

  • You can click on the different Trend types to view how they will predict the data

    (If you see it predicts negative gasoline prices, for instance, you may want to change trend types)

R squared values

R-Squared values

Gauge the accuracy of how a trendline fits the underlying data.

They range from 0 to 1, with higher numbers (closer to 1) being better fits, but you will likely never get a value of 1.

Viewing the r squared values

Viewing the r-SquareD values

At the bottom of the Format Trendline dialog box, click on “Display R-squares value on chart”.

You can then select between the different chart types to view which fits the data the best.

Trendline equations

Trendline equations

Under the Format Trendline dialog box, you can also view the trendline equations.

Due dates

Due dates

  • Homework I: 09/12/2014

  • MyITLab B: 09/15/2014

  • Homework II: 09/19/2014

Next class

next class

  • Excel Chapter 5 / Chapter 6

  • Look over Supplemental Content discussed today

  • Login