EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Tableau Dual Axis
Secondary Sidebar
Tableau Tutorial
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Tableau Dual Axis

By Priya PedamkarPriya Pedamkar

tableau dual axis

Introduction to Dual Axis in Tableau

Dual Axis refers to the fact that we have two axes over the same graph. An axis is a very important component of any graph, and it represents the quantitative measure based on which visualization is created. In some situations, we may intend to analyze multiple measures simultaneously. Having them plot as different graphs may not be that insightful and deriving suitable meaning out of the insights may not be easy. Dual-axis overcomes these issues owing to its ability to have graphs for multiple measures over the same plot. Tableau allows applying Dual-axis in a very easy manner.

How to Apply Dual Axis in Tableau?

In order to understand how Dual-axis can be applied, and other features related to it, we shall go through the following demonstration. The dataset used here contains daily temperature and precipitation data for a month. Using the concept of dual-axis we will try to study the daily pattern for temperature and precipitation. This can be accomplished using a dual-axis. The measures present in the dataset are “Precipitation in %” and “Temperature in Celsius”, while City and Date are the dimensions.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Let’s now proceed to understand how the dual-axis can be applied for a meaningful analysis. This is as described in the following section.

Step 1: First load the requisite dataset into Tableau. For this click on the Data menu, and under it, click on the “New Data Source” option. Alternatively, one can also load the data source by clicking on “Connect to Data”.

Tableau Dual Axis

Step 2: Select the requisite data source type. In this case, it is Microsoft Excel. This is as shown below.

Tableau Dual Axis

Step 3: The data gets loaded and can be seen in the “Data Source” tab. Examine the data prior to proceeding to the analysis. The following screenshot shows this.

Tableau Dual Axis

Step 4: Moving to the sheet tab, one can find the dimensions and the measures present in the requisite sections as shown below.

Tableau Dual Axis

Step 5: First drag the Date dimension into the Columns region or just double click over it. As shown in the following screenshot, automatically, the YEAR function gets applied over the Date dimension.

Tableau Dual Axis

Step 6: We want the graph to be generated day wise. So, in order to change the automatically applied YEAR function, as shown above, click on the drop-down menu of the Date dimension in the Columns region. From the menu, select the “Day” function as shown in the following screenshot.

Tableau Dual Axis

Step 7: When Day function gets applied, as shown in the following screenshot, day-wise data appears.

Tableau Dual Axis

Step 8: Now, we shall bring the measures “Precipitation in %” and “Temperature in Celsius” into the analysis. Just double click over them, and we get a table giving date wise values for the two measures. This is as shown in the below screenshot.

Tableau Dual Axis

Step 9: In order to create visualization over the above data, go to “Show Me”. In Show Me, click on the “horizontal bars” symbol.

Horizontal Bars

Step 10: Following the above steps result in the generation of two horizontal bar graphs, as shown in the following screenshot.

Tableau Dual Axis

Step 11: Studying the bar graphs in the above screenshot is difficult. We will convert them into vertical bar graphs using Ctrl + W command. The vertical graphs are as shown below. Now, the graphs present the insights much better.

Tableau Dual Axis

Step 12: Bar graphs, as shown above, allow better insight capturing. However, in order to analyze temperature vs precipitation trends, the line chart is the most effective. We shall convert both the horizontal charts into line charts. This is simple. Just change the type of both the charts to “Line” from the menu in the Marks card. This is as highlighted in the below screenshot.

Line Form

Step 13: Following the above steps gives us the line charts as shown by the below screenshot. They are present as two different graphs and it is difficult to analyze the patterns of the measures. Using dual-axis, we can compare the daily temperature vs precipitation trend.

Tableau Dual Axis

Step 14: Now, we’ll create a dual-axis. A very important thing to note here, dual-axis can be created for the measure which is present on the right side amongst the two measures in the Rows region. Like in this case “Temperature in Celsius” is present on the right side, so, we can create a dual-axis for it. In order to have a dual-axis, just click on the drop-down menu of the measure. From the menu select “Dual Axis”. This is illustrated in the following screenshot.

Temperature in Celsiu

Step 15: We have successfully created a dual-axis which is as shown in the below screenshot. A couple of important things to note here: two-line charts representing two different measures appear as two different categories represented through different colors. The categories appear on the right side of the screenshot. A secondary axis has got generated for the “Temperature in Celsius” measure. This can be seen on the right side of the plot.  Note, based on the range of values for a particular measure, the maximum value for the axis is decided.

Different Measures Appear

  • The maximum value for both primary and secondary axes isn’t the same. This limitation is overcome by dual-axis which allows us to compare two measures at a time irrespective of the range of its values.
  • The above analysis using dual-axis allows us to easily compare the temperature vs precipitation trend. We can see that though the temperature isn’t varying much, precipitation is fluctuating as depicted by the jagged line chart.

Step 16: We can analyze the trend using the area chart also. However, for using area charts, drag “Precipitation in %” to the right side, and create a dual-axis for it.

Create a dual axis

Step 17: As we can see in the below screenshot, we got area charts for two measures using dual axis. We kept “Precipitation in %” to the right side, because, otherwise, it would have got eclipsed by the area graph of “Temperature in Celsius” measure. The position of the measure in Rows or Columns region must be set accordingly, as it affects the visualization.

Temperature in Celsius

Conclusion – Tableau Dual Axis

When it comes to analyzing multiple measures simultaneously, the concept of dual-axis proves handy. Tableau offers a very easy-to-implement method for applying the dual axis. This approach is in fact, much simpler than the one available in Excel. Moreover, through settings, we can modify the axis as per the requirements.

Recommended Articles

This is a guide to Tableau Dual Axis. Here we discuss an introduction and steps to understand how Dual-axis can be applied with related features. You can also go through our other related articles to learn more –

  1. Dashboard in Tableau
  2. Hierarchy in Tableau
  3. LOD Expressions in Tableau
  4. Google Data Studio vs Tableau
  5. How to Use Tableau Fixed Function?
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more