Table of content

Motion Charts in Tableau

Motion charts are those which show data using the X and Y-axes, displaying changes over time by showing the movement of data points within the defined space as well as changes in the color of the lines.

The main advantage of a motion chart is to view the entire trail of how the data has changed over time and not just a snapshot of the data.

Tableau needs one Time Dimension and one Measure to create a Motion chart.

Creating a Motion Chart in Tableau:

  • Open Tableau and click on Connect to Data.
    connect-to-data-tableau
  • Then the Connect page will open, click on Microsoft Excel.
    click-on-connect-to-data-excel-file-tableau
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
    connect-sample-superstore-to-tableau
  • You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
    naviagte-to-sheet1-tableau
  • The Sample Superstore.xls excel file contains the below details.
    sample-superstore-excel-file-tableau
  • We have to find the variation in profits over months.
  • Drag the dimension Order date to the column shelf, drag it again to the Pages Shelf.
    order-date-with-column-and-page-shelf-tableau
  • In the Pages shelf, right-click on the Order Date and choose Month.
    right-click-on-order-date-and-select-month-tableau
  • Now, drag the measure Profit to the Rows Shelf, the following chart appears.
    motion-chart-tableau
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions