Users can utilize data within a Google Sheet to make a visualization that represents that information within a chart, and to bring together all available data points into one place. This lesson guides users through creating a visualization with a Google Sheet.
Before You Begin
Required Permissions: Access District Achievement Dashboard OR Manage District Achievement Dashboard
This lesson begins assuming a Dashboard has already been created. If one has not been created, take a look at Create a New Dashboard.
Where to Start
- Select New Visualization.
- Choose Google Sheet.
Google Sheet Visualizations
- Enter a Name for the visualization.
- Enter a URL for the Google Sheet.
- The data must be within a Google Sheet. It must also contain numerical data that is blocked together within the sheet.
- The data intended for the visualization should have a header row to describe the columns, and the first column to describe the rows.
- The Google Sheet must have the Share settings set as "Anyone with the link" is a "Viewer."
- The Starting Cell should reflect the first cell in which the visualization should start, typically A1 or A2.
- The Ending Cell or Column should reflect where the last point of data is within the sheet.
- Select a Visualization Type. This determines how the data is displayed. Options include a Bar Chart, Column Chart, Line Chart, and Table.
- Select Load Sheet to see a preview of the visualization.
- Select Flip Grouping if the data on the chart needs to swap the x and y axis.
- Enter a Short Description as needed to provided more details on the data.
- Select the arrow icon to expand possible Display Settings, such as an Axis Minimum and Maximum.
- Select Save to create the visualization.
Next Steps
To learn more, visit the Visualization manual.