5.1 Scatter Plot (Tableau)

 

5.1 Scatter Plot

In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf. Suppose these shelves contain both dimensions (table) and measures, Tableau places the measures as the innermost fields, it means that measures are always to the right of any dimensions that you have also placed on these shelves.

To use scatter plots and trend lines to compare sales to profit, follow these steps:

1. Open the Sample - Superstore data source.

2. Drag the Profit measure to Columns.

Tableau aggregates the measure as a sum and creates a horizontal axis.

3. Drag the Sales measure to Rows.

4.      Drag the Category dimension to Color on the Marks card.

5.      Drag the Region dimension to Detail on the Marks card.

6.      To add trend lines, from the Analytics pane, drag the Trend Line model to the view, and then drop it on the model type.

 

5.1.2 Adding labels to scatterplots

Adding these labels is helpful and allows the audience to pick out a few other stories from the view. It’s possible to force Tableau to show all the labels. Select category from table , drag and drop it into label on card board. It shows the labels as follows.

It is recommends that the show labels only for which we want to display.

First and foremost thing is to select the only one category and right click on it , under the menu select the “Annote” and select mark it displays the small window in this remove all except the category then click ok. So that it displays only one label.

Making Scatter plot Exploratory

Using Quick Filters turn a scatterplot into an exploratory interactive. Select sales and profit and right click then select quick filter one by one then the scatter plot will make interactive .

 

Now we can explore this data set in a number of different ways to ask and answer a variety of questions. We can also configure the filters to be different types. To change the position filter from a multiple select to a single select “radio button” style, we can hover over the filter box, click the small down arrow that appears in the upper-right corner, and then select Single Value (list). We can also change the sliders to be one[1]sided: “At Least” or “At Most.”

 Our choice of filter type depends on what we want users to do with the filters. In this case, allowing the users to select only one position at a time makes it more likely that they will create the views

5.1.3 b Adding Background Images

The next step is motivated purely by aesthetics, and it involves adding a background image that gives the effect of Wayne Gretzky sweeping through the other 99 players with a slap shot. To do this, I selected Map → Background Images → [File Name] and then Add Image, which resulted in a dialog box and fill the details as required. Then click ok button.