chart components lesson 6 – working with charts and graphics, continued
DESCRIPTION
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. Lesson 6 - Working with Charts and Graphics Slide 3TRANSCRIPT
![Page 1: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/1.jpg)
CHART COMPONENTS
Lesson 6 – Working With Charts and Graphics, continued
![Page 2: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/2.jpg)
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.
Lesson 6 - Working with Charts and Graphics Slide 2
Data Series
![Page 3: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/3.jpg)
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.
Lesson 6 - Working with Charts and Graphics Slide 3
![Page 4: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/4.jpg)
GRAPH AND CHART PARTS
![Page 5: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/5.jpg)
Lesson 6 - Working with Charts and Graphics Slide 5
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.
0102030405060708090100
Y-A
xis
X-Axis
Data Marker
![Page 6: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/6.jpg)
Data Series
• A collection of related values from the worksheet; one row/column on the spreadsheet.
Lesson 6 - Working with Charts and Graphics Slide 6
Data Series
![Page 7: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/7.jpg)
Gridline
• Horizontal or vertical line that extends across the plot area of the graph to make it easier to read and understand the values.
Lesson 6 - Working with Charts and Graphics Slide 7
Gridline
![Page 8: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/8.jpg)
Plot Area
• The rectangular area bound by the category and values axes.
Lesson 6 - Working with Charts and Graphics Slide 8
Plot Area
![Page 9: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/9.jpg)
Tick Mark
• Used to add clarification to the data categories.
Lesson 6 - Working with Charts and Graphics Slide 9
Tick Marks
![Page 10: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/10.jpg)
Legend
• The object that explains the symbols, colors, or patterns used to differentiate the data.
Lesson 6 - Working with Charts and Graphics Slide 10
Legend
![Page 11: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/11.jpg)
Data Label
• Single value or piece of data from the data series.
Lesson 6 - Working with Charts and Graphics Slide 11
Data Labels
![Page 12: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/12.jpg)
Chart Title
• Describes the purpose and content.
Lesson 6 - Working with Charts and Graphics Slide 12
Title
![Page 13: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/13.jpg)
Axis Titles
• Describe the x and y axis data.
Lesson 6 - Working with Charts and Graphics Slide 13
Axis Titles
![Page 14: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/14.jpg)
Lesson 6 - Working with Charts and Graphics Slide 14
7.
1.
6.
8.
5.3.
2.
9.
4.
10.
Now it’s your turn1. 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
![Page 15: CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued](https://reader035.vdocuments.us/reader035/viewer/2022062219/5a4d1b257f8b9ab059996f63/html5/thumbnails/15.jpg)
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.
Lesson 6 - Working with Charts and Graphics Slide 15
Linked Chart• A linked chart is one that will change to reflect
changes made to the spreadsheet it represents.