Work With Data to Create Charts

It is often helpful to view and interpret analytical results when they are presented visually. Graphs and charts help readers digest and interpret information quickly, consistent with the familiar adage "a picture is worth a thousand words." Let’s see what we can see in your data analysis.

Create the following graphs in your workbook on a separate tab named Graphs_Charts:

  1. Create separate pie charts that show percentages of employees by (1) gender, (2) education level, and (3) marital status. Explore pie chart formats.
  2. Create separate bar charts that show the (1) number of employees by race and (2) the number of employee per state.
  3. Create a line graph for the sales summary provided.
  4. Create a histogram that shows the number of employees in incremental salary ranges of \$10,000. Show how many employees are in each of these salary buckets: \$0–\$20,000; \$20,001–\$30,000; \$30,001–\$40,000; and so forth, up to the highest salary range. This involves counting how many employees are in each "salary bucket" to create a frequency distribution table and histogram. Histograms seem hard, but mastering how to visualize the frequency of events is helpful for analysis.
Screenshot of a pie chart, bar chart, and line chart in Microsoft Excel.

Used with permission from Microsoft.

Note: Your Excel spreadsheet template has the upper limit and labels already identified. Complete the table and histogram by engaging the Data Analysis Toolpak. Place the output on a new worksheet and label it Histogram.