Evolytics Blog

Tableau 201: How to Make Dual-Axis Slope Graphs

Tableau Dual-Axis Slope Graphs FeatureSlope graphs, or essentially line graphs between two points, are one of my favorite Tableau charts when my analysis requires a comparison between two data points. They work so well, in fact, that they are the one chart I will use to connect lines between discrete categorical variables. In almost every scenario, lines should only be used to connect points in time, but with slope graphs, I am okay drawing a line between ‘Thing 1’ and ‘Thing 2’, as well as ‘Time 1’ and ‘Time 2’.

This post shares not only how to make slope graphs in Tableau, but how to enhance them by leveraging a second axis to provide additional context.

How to Make Slope Graphs in Tableau

First, let’s knock out the traditional slope graphs using this data:

Tableau Traditional Slope Graphs Data

Step 1 – Create a Bar Chart

Create a bar chart with your 2-point time comparison on the columns shelf as a discrete dimension and your measure on the rows shelf.

Tableau Traditional Slope Graphs Bar Chart

Step 2 – Add Dimension to Level of Detail

Add the dimension you are wanting to compare to the Detail marks card. This will eventually create one line per categorical variable.

Tableau Traditional Tableau Slope Graphs with Level of Detail

Step 3 – Change the Mark Type to Line

Change the mark type from Automatic (currently set to bar) to line to create slope graphs.

Tableau Traditional Slope Graphs Unformatted

Step 4 – Format

To finalize the view, add labels and markers to the line ends. To update the labels, place the fields you want on the view to the Label marks card, and edit the Label marks card to show labels on the line ends. The markers are added by editing the Color marks card.

Tableau Traditional Slope Graphs Final

How to Make Dual-Axis Slope Graphs in Tableau

Disclaimer before I let the genie out of the bottle: In the Thing 1 vs. Thing 2 scenario I’m about to share, I only think this works well if you are comparing exactly two things. Once you get beyond two things, the visualization officially becomes a line graph, and should never be used to connect dimensions that are not elements of time. The best practice is a simple bar chart.

For the purposes of this exercise, the underlying data looks like this:

Tableau Slope Graphs Data

Our final product will look like this:

Slope Graph Feature

I’m using a Company A vs. Company B scenario just to show a slightly different use case, but this same exact process is applicable if you are comparing two points in time.

Step 1 – Create a Bar Chart

As mentioned above, the first step to creating slope graphs is to get the columns set up with whatever dimensions we are comparing. Sometimes with traditional slope graphs, there can be overlapping points and labels if data points are too close together. In that case, and when comparing two things (vs. times), I prefer to place the more granular dimension (in our case, social network) on the columns shelf first, followed by the dimension that includes ‘Thing 1’ and ‘Thing 2’ or ‘Time 1’ and ‘Time 2’. The measure we are analyzing goes on the rows shelf, to end up with a bar chart view like this:

Tableau Slope Graphs Bar Chart

Again, this chart type is best practice when we are comparing two discrete categorical variables such as Company A vs. Company B, so stop here if you are feeling any discomfort with looking at this in a different way.

Step 2 – Change Mark Type to Line

From here, a bar chart is converted into a slope graph by simply changing the mark type on the view from bar to line.

Tableau Slope Graphs

You can get a nice look from here by adding markers to the line ends.

Tableau Slope Graphs with Markers

At this point, you already have slope graphs in Tableau. This is an awesome chart type. If you want an incredibly awesome chart type, keep reading.

Step 3 – Create a Dual-Axis Combo Chart

Create a dual-axis combo chart by dragging the measure you’re interested in (in our case, Size of Audience) to the opposite axis, and change the mark type on the second marks card to circle. If you are not familiar with building dual-axis combo charts, be sure to check out the post, How to Make Dual-Axis Combo Charts in Tableau.

For best results, also be sure to synchronize the second axis by right-clicking on the right-axis and choosing “Synchronize Axis”. At this point, my chart looks like this:

Tableau Dual-Axis Slope Graph

Step 4 – Customize the Second View

Now that we have two measures on the rows shelf, we have two marks shelves that we can edit independently of each other. This means we can keep the slope graph on one marks shelf, but change the size, colors, and context on the circles in the secondary marks shelf.

As just one example, I’ll use the circles to display the delta between ourselves and our main competitor. I will also color both the slope graphs and circles to make our brand clear on the view. Here are the steps:

  1. Change the sort order so the top competitor is listed first and Our Awesome Company is listed second. This is more intuitive when you are comparing things across a table. The sort order can be changed by clicking on the Company dimension on the columns shelf.
  2. Add the Size of Audience measure to the label marks card.
  3. Add a quick table calculation to the Size of Audience measure for Percent Difference.
  4. Edit the table calculation to compute the percent difference along Pane (Across). This will execute the table calculation for each social network column.
  5. Add the Company dimension to the color marks card of both the slope graph and the circles (which is actually a dot plot) mark cards.

After some basic formatting, I end up with this:

Final Tableau Slope Graphs

This is just one example, but you can use this approach with other mark types, to show different KPIs, and/or to color based on performance such as a stoplight index. Slope graphs are an excellent choice for comparing two things – especially changes over two points in time – and they are made even stronger when additional context is added by leveraging a dual-axis in Tableau.

Ryan Sleeper

Ryan Sleeper is a data visualization evangelist specializing in Tableau. To learn more about how Evolytics' award-winning data visualization practice can help you with your Tableau dashboards or training needs, contact us.

Tableau 201: How to Make Dual-Axis Slope Graphs

Related Posts