HOW THIS GUIDE CAN HELP YOU
This guide shows you how to create different charts and graphs in Google Sheets. It covers the basics, like what each chart type is and when it's useful, and provides a short step-by-step video. Each page focuses on a specific visualization, making it easy to find what you need. There's also a section on linking your Sheets to Google Docs.
Need help visualizing your data? If you have questions or need some extra guidance just reach out. I'm also available for in-person or Zoom meetings. Email me at monger@wou.edu
Robert Monge - Instruction Librarian
TYPES OF DATA VISUALIZATIONS IN THIS GUIDE
BasicTable: Organizes data in rows and columns. Use for precise values, comparisons, and detailed information.
Pie Chart: Shows parts of a whole (100%) using slices. Best for a few categories (5-7).
Bar Graph: Compares category values with bars. Great for quantities, frequencies, and scores.
Line Graph: Shows trends and changes over time by connecting data points.
Histogram: Displays the distribution of numerical data in bins, showing the shape (normal, skewed, etc.).
Scatter Plot: Shows the relationship between two variables and identifies correlations and outliers.
HOW TO ACCESS GOOGLE SHEETS
To access Google sheets open your WOU email and from the top of the screen select Google Apps. Scroll down to access Sheets.
Ask WOU Library