Drag and drop the Excel Spreadsheet under the title Connections
Notice the Clean with data interpreter box is checked. Drag education attainment from under the Sheets column and Tableau creates a preview of our data set.
You can rename your columns here by clicking on each heading in the data set to make the change. If happy with how data looks open your first worksheet.
Under Dimensions column “Measure names” is dragged.
Sheet 1 renamed levels in population. After Levels dragged and U.S. and Chicago Dragged.
Sheet 2 added Level and Measure names
Moved level to columns and dragged U.S and Chicago data to rows. Renamed Sheet 2
image7.png
image8.png
image9.png
image1.png
image2.png
image3.png
image4.png
image5.png
image6.png