Sponsored Links
This presentation is the property of its rightful owner.
1 / 39

Day 7: Excel chapter 4 PowerPoint PPT Presentation

  • 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 [email protected] September 10th , 2014. Homework #1. Due this Friday 09/12 by midnight 20% penalty for each day late

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

“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

[email protected]

September 10th, 2014

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!


What is a visual representation of numerical data?


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

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 Area

Plot Area

Category Axis(X Axis)

Value Axis

(Y Axis)

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

Clusters of columns side by side for easy comparison.

Stacked column chart

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

100% stacked column chart

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


Looks pretty.

Bar charts

  • Displays data horizontally in rows. (bars)

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

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

Multiple data series

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

Exploded 3d pie

Stop: Project time

In Class Chart Demo

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

  • Select Chart

  • Design Ribbon

  • Data Group -> Select Data

  • Remove/Add/Delete

Switching rows/columns

  • Select Chart

  • Design Ribbon

  • Data Group -> Switch Row/Column

Chart styles

Can be applied to already made charts.

  • Select Chart

  • Design Ribbon

  • Chart Style Group -> Select Style

Embed an Excel chart

  • Insert Ribbon

  • Click Object

  • Create New

  • Microsoft Excel Chart

  • Click OK

  • Replace the Sample Data in Sheet 1

Sample chart

You can also, copy/paste

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

  • Linear Trendline

  • Exponential Trendline

  • Linear Forecast Trendline

  • Two Period Average Trendline

Adding trendlines

Select Data Series (In this case C grades)

Adding trendlines - cont’d

The trendline

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

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

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

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

Due dates

  • Homework I: 09/12/2014

  • MyITLab B: 09/15/2014

  • Homework II: 09/19/2014

next class

  • Excel Chapter 5 / Chapter 6

  • Look over Supplemental Content discussed today

  • Login