• Unit 1: Presenting Data with Charts

    We often use charts to organize our data and help our audience visualize information and grasp concepts more quickly. The best type of chart to use depends on the information you are presenting. For example, you might use a pie chart to compare sales totals from five or six branch offices of a company. However, a pie chart is not as useful for looking at sales trends over five years; a line or scatter plot would be more appropriate for visualizing trends over time.

    Completing this unit should take you approximately 2 hours.

    • 1.1: Types of Charts

      Spreadsheet programs, such as Microsoft Excel and Google Sheets, have a variety of different chart options. In this section, we explore the types of charts available in these spreadsheet programs and how to create them.

    • 1.2: Choosing a Chart

      Now that we know how to make the most common types of charts, we need to understand when to use them. Line charts are useful for looking at interest rate trends over time: the x-axis represents time, and the y-axis is the quantity of interest. A line chart is also a good choice for reviewing income throughout the year. We use pie graphs to compare groups, such as to compare sales in different branches of the same company. We use column graphs, bar graphs, stacked column graphs, or stacked bar graphs to compare items in different categories, such as different types of survey data.

    • Unit 1 Assessment