Chart Components

4.02 Understand charts and graphs used in business

Revised by A. Moore 4-2012

4.02 Understand charts and graphs used in business Slide 2

Why do you need to learn about charts?

Why might you use a chart to present spreadsheet information?

What does a chart do that a spreadsheet does not?

4.02 Understand charts and graphs used in business Slide 3

Data Series

Is it a chart or a graph?

A graph is a feature of a chart used to plot data.

The chart is the total package

Chart includes the title, value labels, and legend.

4.02 Understand charts and graphs used in business Slide 4

Examples of business uses of charts To represent sales trends within the different

departments of a store. To represent the contribution of individual

employee sales to the total sales for a company.

To represent the percent of each expense to total expenses.

To explain stock price fluctuations to stock holders.

Graph and Chart Parts

4.02 Understand charts and graphs used in business Slide 6

Components of Graphs & Charts

Y- axis - left vertical side; contains numerical data.

X-axis - bottom horizontal side; contains the category information.

Data markers –symbol in a chart that represents a single data point.

0102030405060708090100

Y-A

xis

X-Axis

Data Marker

4.02 Understand charts and graphs used in business Slide 7

Data Series

Data Series

Related data points that make up a series that are plotted in a chart.

4.02 Understand charts and graphs used in business Slide 8

Gridline

Horizontal or vertical line that extends across the plot area of the graph

Makes it easier

to read and understand the values.

Gridline

4.02 Understand charts and graphs used in business Slide 9

Plot Area

The rectangular area that includes the data series, category names, tick-mark labels, and axis titles).

Plot Area

4.02 Understand charts and graphs used in business Slide 10

Tick Mark

Small lines, like divisions on a ruler, that intersect the axis.

Adds clarification to the data categories.

Tick Marks

4.02 Understand charts and graphs used in business Slide 11

Legend

Box that identifies patterns, symbols, or

colors in the chart

Legend

4.02 Understand charts and graphs used in business Slide 12

Chart Title Describes

the purpose and content.

Title

4.02 Understand charts and graphs used in business Slide 13

Axis Titles Describe the

x axis (horizontal) and y axis (vertical) data.

Axis Titles

4.02 Understand charts and graphs used in business Slide 14

Data Label

Single value or piece of data from the data series.

Adds extra information about the data marker.

Data Labels

4.02 Understand charts and graphs used in business Slide 15

Now it’s your turn!

See if you can identify all of the components and describe their functions.

7.

4.

1.

6.

5.

8.

3.

2.

9.

10.

4.02 Understand charts and graphs used in business Slide 16

7.

1.

6.

8.

5.3.

2.

9.

4.

10.

How’d you do?

1. Data Series

2. Chart Title

3. Y Axis Labels

4. Data Labels

5. Plot Area

6. Gridline

7. Legend

8. X Axis Labels

9. X Axis Title

10. Tick Mark

4.02 Understand charts and graphs used in business Slide 17

Embedded vs. Separate Embedded chart - placed on the same

sheet you are working on rather than another worksheet.

Separate chart – (aka chart sheet) appears on a separate sheet.

4.02 Understand charts and graphs used in business Slide 18

Linked Chart A linked chart is one that will change to

reflect changes made to the spreadsheet it represents.

Chart Wizard

4.02 Understand charts and graphs used in business Slide 19

Step-by-step process for creating a chart in Microsoft Excel.

Bar (Column) Chart / Histograms

Slide 20

Bar chart – uses bars to compare changes of two or more values over a period of time.

Histogram - uses bars to represent frequency of numerical data organized in intervals (Ex: 0-20)

Stacked Bar Chart

4.02 Understand charts and graphs used in business Slide 21

•Represents the contribution of individual items to a whole

•Each bar is divided into two or more parts

•The length of the stacked bar represents a total for any given month

Spirit Participation

0 50 100 150 200

January

February

March

April

Mo

nth

PercentSophomoresJuniorsSeniors

Line Chart

4.02 Understand charts and graphs used in business Slide 22

Line Chart - uses points connected by lines to show trends over time).

•Example: Trends in sales of three stores within a three month period.

XY Scatter Chart

4.02 Understand charts and graphs used in business Slide 23

•Two value axes thatshows one set of numerical data along the x-axis and another along the y-axis.

• Example: •Determines how stress effect pulse rate .

The Effect of Region 3 Absences on Sales

-

10,000

20,000

30,000

40,000

50,000

60,000

70,000

80,000

90,000

0.0 2.0 4.0 6.0 8.0

Absences

Sal

es (i

n Th

ousa

nds)

King, Karl

Lemmons, Leslie

Murdoch, Martin

0.0

1.0

2.0

3.0

4.0

5.0

6.0

7.0

8.0

- 20,000 40,000 60,000 80,000 100,000

5.

Pie

4.02 Understand charts and graphs used in business Slide 24

•Represents the percentage each item contributes to the total.•Example: Highest sales percentages in Region 2

6.

Exploded Pie Chart

4.02 Understand charts and graphs used in business Slide 25

Exploded Pie Chart - slice pulled away to draw attention or emphasize

a point.

WDYK…RYS…YIA Put all notes away. QUIETLY take out a sheet of notebook

paper. In the right corner: Write your fname, lname,

class, and date. Number your notebook paper from 1-10. Now the fun begins

4.02 Understand charts and graphs used in business Slide 26

4.02 Understand charts and graphs used in business Slide 27

Identify each component.

Chart title

Data labels

Data series

Gridlines

Legend

Plot area

Tick mark

X axis labels

X Axis title

Y Axis labels

7.

4.

1.

6.

5.

8.

3.

2.

9.

10.