Downloaded 10 times
Uploaded bylindy23
Chart Components
Charts and graphs are used in business to present spreadsheet information in a visual format that is easier to understand than raw numbers. A chart includes a title, value labels, and legend to plot data from one or more data series on a graph with an x-axis, y-axis, and data markers. Common chart components are the plot area, gridlines, tick marks, legend, data labels, axis titles, and chart title, each serving to clearly display and identify the visualized data.
More Related Content
Chart Components
- 1. Chart Components 4.02Understand charts and graphs used in business.
- 2. Why do youneed 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 achart 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
- 4. Examples of businessuses 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 ChartParts
- 6. Components of Graphsand Charts Y- axis - t he left vertical side; it contains the numerical data. X-axis - t he bottom horizontal side; it contains the category information. Data markers - represent values. Y-Axis X-Axis Data Marker
- 7. Data Series Acollection of related values from the worksheet; one row/column on the spreadsheet. Data Series
- 8. Gridline Horizontal orvertical line that extends across the plot area of the graph to make it easier to read and understand the values. Gridline
- 9. Plot Area Therectangular area bound by the category and values axes. Plot Area
- 10. Tick Mark Usedto add clarification to the data categories. Tick Marks
- 11. Legend The objectthat explains the symbols, colors, or patterns used to differentiate the data. Legend
- 12. Data Label Singlevalue or piece of data from the data series. Data Labels
- 13. Chart Title Describesthe purpose and content. Title
- 14. Axis Titles Describethe x and y axis data. Axis Titles
- 15. Now it’s yourturn! See if you can identify all of the components and describe their functions. 7. 4. 1. 6. 5. 8. 3. 2. 9. 10.
- 16. 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 7. 1. 6. 8. 5. 3. 2. 9. 4. 10.
- 17. Embedded vs. SeparateAn 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 Alinked chart is one that will change to reflect changes made to the spreadsheet it represents.
- 19.