CHART COMPONENTS Lesson 6 Working With Charts and

CHART COMPONENTS Lesson 6 – Working With Charts and Graphics, continued

Lesson 6 - Working with Charts and Graphics 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?

Lesson 6 - Working with Charts and Graphics Slide 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. Data Series

Lesson 6 - Working with Charts and Graphics 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

Lesson 6 - Working with Charts and Graphics Slide 6 Components of Graphs and Charts n n 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. Data Marker Y-Axis n X-Axis

Lesson 6 - Working with Charts and Graphics Slide 7 Data Series • A collection of related values from the worksheet; one row/column on the spreadsheet. Data Series

Lesson 6 - Working with Charts and Graphics Slide 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. Gridline

Lesson 6 - Working with Charts and Graphics Slide 9 Plot Area • The rectangular area bound by the category and values axes.

Lesson 6 - Working with Charts and Graphics Tick Mark • Used to add clarification to the data categories. Tick Marks Slide 10

Lesson 6 - Working with Charts and Graphics Legend • The object that explains the symbols, colors, or patterns used to differentiate the data. Slide 11

Lesson 6 - Working with Charts and Graphics Slide 12 Data Labels • Single value or piece of data from the data series.

Lesson 6 - Working with Charts and Graphics Chart Title • Describes the purpose and content. Slide 13

Lesson 6 - Working with Charts and Graphics Axis Titles • Describe the x and y axis data. Slide 14

Lesson 6 - Working with Charts and Graphics Slide 15 Now it’s your turn! See if you can identify all of the components and describe their functions. 2. 1. 5. 3. 4. 7. 6. 10. 8. 9.

Lesson 6 - Working with Charts and Graphics Slide 16 How’d you do? 2. 1. 1. Data Series 2. Chart Title 3. Y Axis Labels 5. 3. 4. Data Labels 5. Plot Area 6. Gridline 7. Legend 7. 6. 8. X Axis Labels 10. 9. X Axis Title 10. Tick Mark 8. 9.

Lesson 6 - Working with Charts and Graphics Slide 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. Linked Chart • A linked chart is one that will change to reflect changes made to the spreadsheet it represents.