Comment on page
Data Viz with Spreadsheets Exercise
Objective: Experience how to import CSV data into a spreadsheet, create charts from the data and compose the charts into a visualization document. Your goal for this exercise is to create a visualization that looks something like the example below. You will start with the same data and use Google Sheets to create the charts. You can then copy and paste charts into Google Drawing to create a refined composite of the charts.
- 3.Create a scatterplot comparing the "rank" and "metascore" for the movie-goer dataset and customize the vertical axis to have a minimum value that displays the data with more detail and less white space. Similarly create a scatterplot comparing the "rank" and "avg_vote" for the critics dataset. Video (Note: Video selects avg_vote in error)
- 5.Update the title and axis labels to be like the example visualization and update the colors.
- 6.Start a Google Drawing and set the page to 17" wide by 11" tall.
- 7.Copy and paste your charts from Google Sheets into your drawing and resize as needed.