Chart Components

1
Chart Components
4.02 Understand charts and graphs used in
business.
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?

3
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 that includes the
  title, value labels, and legend.

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.

5
Graph and Chart Parts
6
Components of Graphs and Charts

• Y- axis - the left vertical side it contains the
  numerical data.
• X-axis - the bottom horizontal side it contains
  the category information.
• Data markers -represent values.

7
Data Series

• A collection of related values from the
  worksheet one row/column on the spreadsheet.

8
Gridline

• Horizontal or vertical line that extends across
  the plot area of the graph to make it easier to
  read and understand the values.

9
Plot Area

• The rectangular area bound by the category and
  values axes.

10
Tick Mark

• Used to add clarification to the data categories.

11
Legend

• The object that explains the symbols, colors, or
  patterns used to differentiate the data.

12
Data Label

• Single value or piece of data from the data
  series.

13
Chart Title

• Describes the purpose and content.

14
Axis Titles

• Describe the x and y axis data.

15
Now its your turn! See if you can identify all
of the components and describe their functions.
16
Howd 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
17
Embedded vs. Separate

• An embedded chart is one that appears on the same
  sheet as the worksheet it represents.
• A separate chart is one that does not appear on
  the same sheet as the worksheet it represents.

18
Linked Chart

• A linked chart is one that will change to reflect
  changes made to the spreadsheet it represents.