1 / 19

Understanding Charts and Graphs in Business for Effective Data Presentation

This guide explores the importance of charts and graphs in business data presentation. Learn how charts can enhance your understanding of spreadsheet information, illustrating sales trends, employee performance, and expense breakdowns. Discover the components of charts and graphs, including axes, data markers, plot areas, and legends, and how they contribute to conveying complex data visually. Additionally, understand the differences between embedded, separate, and linked charts in spreadsheets, enhancing your data analysis skills and improving communication with stakeholders.

eman
Download Presentation

Understanding Charts and Graphs in Business for Effective Data Presentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  3. Data Series Is it a chart or a graph? • A graph is a feature of a chart used to plot data. (includes plot area, gridlines & values) • The chart is the total package that includes the title, labels, legend, color & adds meaning to the graph. 4.02 Understand charts and graphs used in business

  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 stockholders. 4.02 Understand charts and graphs used in business

  5. Graph and Chart Parts

  6. Data Marker Y-Axis X-Axis 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 data values. 4.02 Understand charts and graphs used in business

  7. Data Series Data Series • A collection of related values from the worksheet; one row/column on the spreadsheet. 4.02 Understand charts and graphs used in business

  8. Gridline Gridline • Horizontal or vertical line that extends across the plot area of the graph to make it easier to read and understand the values. 4.02 Understand charts and graphs used in business

  9. Plot Area Plot Area • The rectangular area bound by the category (x) and values (y) axes. • The background portion of the graph. 4.02 Understand charts and graphs used in business

  10. Tick Marks Tick Mark • Used to add clarification to the data categories or values. 4.02 Understand charts and graphs used in business

  11. Legend Legend • The object that explains the symbols, colors, or patterns used to differentiate the data. 4.02 Understand charts and graphs used in business

  12. Data Labels Data Label • Single value or piece of data from the data series. 4.02 Understand charts and graphs used in business

  13. Title Chart Title • The main heading that describes the purpose and content. 4.02 Understand charts and graphs used in business

  14. Axis Titles Axis Titles • Describe the x and y axis data. • The x axis describes the horizontal data. • The y axis describes the vertical data. 4.02 Understand charts and graphs used in business

  15. 2. 1. 5. 3. 4. 7. 6. 10. 9. 8. Now it’s your turn! See if you can identify all of the components and describe their functions. 4.02 Understand charts and graphs used in business

  16. 2. 1. 5. 3. 4. 7. 6. 10. 9. 8. 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

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

  18. Linked Chart • A linked chart is one that will change to reflect changes made to the spreadsheet it represents. 4.02 Understand charts and graphs used in business

  19. The End 4.02 Understand charts and graphs used in business

More Related