Create XY Scatter Chart with Tableau Public
last updated March 16, 2017
An interactive scatter chart shows the relationship between two variables by displaying a series of XY coordinates. Readers can float their cursor over points to view specific details. The chart below, which illustrates the strong relationship between Connecticut school district income and test scores, was created with the free downloadable tool for Mac and Windows, Tableau Public http://public.tableau.com.
Video with step-by-step tutorial
Click the link and Save to download the sample file to your computer: ct-districts-income-grades-2009-13 in Excel format.
Open the sample file to view three columns: district, median household income, and grade levels (above/below national average for 6th grade Math and English test scores). The Notes tab explains how this data is based on the work of Sean Reardon et al. at the Stanford Education Data Archive, Motoko Rich et al. at The New York Times, Andrew Ba Tran at TrendCT, and the American Community Survey 2009-13 via Social Explorer.
Hint: To prepare your own scatter chart data from different sources, see the Match Spreadsheet Columns with VLookup Function chapter in this book.
In Tableau Public, click Connect to import the data file from your computer. If you downloaded an Excel file, Connect to Excel. Or if you downloaded a CSV file, Connect to Text. Or click “More…” to connect to Google Sheets.
Drag the Data sheet into the Data Source field.
In bottom-left corner, below the “Go to Worksheet” reminder, click Sheet 1.
Welcome to the Tableau Public Worksheet. Although it may feel overwhelming at first, the key is learning where to drag items from the data tab into the main worksheet. Dimensions are any information that is qualitative or categorical, while measures are quantitative information about the dimensions.
Drag the Grade Levels measure into the Rows field.
Drag the Median Household Income measure into the Columns field. The initial chart will appear as one point, but that’s because all of the data is aggregated together. We’re not done yet.
Drag the District dimension into the lower portion of the Marks area. Now your scatter chart will appear, and float your cursor over each point to view details.
Click Sheet 1 to rename the title of your chart.
Click the Worksheet menu to Show Caption and type in data sources.
Recommended: Click the Standard menu (above Columns) to change view to Fit Width.
To publish your chart on the public web, select File > Save to Tableau Public As. Requires signup for a free Tableau account.
Give your workbook a meaningful title, since this name will appear in the URL for your published work on the Tableau Public server, and press Save.
After publishing your work on the web, Tableau Public will automatically open the web link in your default browser. Click Edit Details to enter more information. Under Toolbar settings, see checkbox to Allow your workbook and its data to be downloaded by others.
Checking this box enables the Download button at the bottom of your published work, which allows users to access your data and workbook, to see how you constructed the visualization.
To see all of your published visualizations, go to your Tableau Public online profile, which follows this format:
- Combine multiple visualizations and tell stories with Tableau Public dashboard and story point features. See Tableau Public Resources, with how-to videos and sample data https://public.tableau.com/en-us/s/resources.