Last Modified Date: 26 May 2017
- Download the attached LongitudeLatitudeTestData.xlsx file, which you will find in the upper right-hand corner of this article under "Attachments".
- In Tableau Desktop, connect to LongitudeLatitudeTestData.xlsx. For more information, see Connect to Data.
- In Measures, right-click Ln, and then select Geographic Role > Longitude.
- In Measures, right-click Lt, and select Geographic Role > Latitude.
- Drag Ln to the Columns shelf.
- Drag Lt to the Rows shelf.
- Drag Place to Detail on the Marks card.
- The longitude and latitude fields in the data source must include at least one decimal place.
- The longitude and latitude must be separate fields in the data source. For example, see attached spreadsheet.
- The example data contains the latitude and longitude values for West Virginia, Virginia, and Maryland. The field and state names are altered so that Tableau Desktop will not automatically recognize them as geographic locations.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials