How to Create a Two Color Area Chart?

a team smiling while working

Creating a two-color area chart in Tableau Desktop is a straightforward process that can be achieved by using the “dual axis” function and creating a calculated field. This type of chart is useful for displaying two different measures on the same chart and comparing their trends over time.

Keep reading: Tableau Desktop Specialist Certification Questions »

Loading RSS Feed
Tableau Two Color Area Chart
Tableau Two Color Area Chart

Desktop Specialist

Learn more about Desktop Specialist Certification.

Data Analyst

Learn more about the Data Analyst Certification.

Server Certified

Learn more about the Tableau Server Certification.

🎁 Did you know you can get $30 for sharing your work and certification experiences? Write and get paid for every article. Learn more »

Step 1: Create a Chart

First, you will need to create an area chart of your first measure. To do this, drag the dimension you want to use on the X-axis and the first measure you want to use on the Y-axis. Then, select the “area” mark type from the top right of the screen.

Step 2: Create a Second Chart

Next, create a second chart for the second measure you want to display. Drag the same dimension to the Columns or Rows shelf, and then drag the second measure to the opposite shelf. Select the same mark type, “area” for this chart.

Step 3: Synchronize the Axis

Now that you have two area charts, you will need to synchronize their X and Y-axes so that they align correctly. To do this, right-click on the axis of one of the charts and select “Synchronize Axis.”

Step 4: Create a Dual Axis

With the two charts sharing the same axis, you will now create a dual axis by dragging the second measure to the right of the first measure on the same chart. Right-click on the axis of the second measure and select “Synchronize Axis”.

Step 5: Create a calculated field

To create a calculated field for the second measure, go to the Analysis menu, and select Create Calculated Field. In the formula area, enter a formula that will differentiate the second measure. For example, if your first measure is sales, and the second measure is profit, you can create a calculated field to show the profit percentage of sales by using the formula:

SUM([Profit])/SUM([Sales])

Step 6: Format the Chart

Once you have created a dual axis, you can format the chart by adjusting the colors and other visual elements to your preference. To format the chart, right-click on one of the measures and select “Format.” From here, you can change the color of the area chart, adjust the axis labels and more.

Keep on Reading: Tableau Data Analyst Certification Questions »

By following these steps, you can easily create a two-color area chart in Tableau Desktop. This type of chart can be a powerful tool for comparing and contrasting different measures over time and making informed business decisions.


Get our Most Popular Downloads

Download the most popular scenario-based Tableau Workbooks in .twbx format. Used by thousands of Tableau developers and job aspirants every day to improve and fine-tune their CV and Tableau Public profile. Join the largest Tableau Experts Social Group.

Tableau Banking and Financial Dataset Analysis Download
Banking & Financial Dataset Analysis

Financial Domain Tableau Dataset and Analysis. The most important domain in today’s industry. Analyze Key Performance Indicators. Discover Risky and Fraudulent Outliers. Download the Tableau Packaged (.twbx) Workbook. Includes a complete Financial dataset analysis. Enhance your Data Analytics experience with our skilled analysis.

Tableau Healthcare and Hospital Dataset Analysis Download
Healthcare & Hospital Dataset Analysis

Hospital and Healthcare Domain Tableau Dataset and Analysis. A key field of study with millions of lives at stake. The most sensitive industry today. Download the Tableau Packaged (.twbx) Workbook. Understand how healthcare datasets work. Includes a complete Healthcare dataset with analytical charts. Explore Tableau interactive features with this download.

Tableau Insurance Dataset Analysis Download
Insurance Dataset Analysis

Insurance Domain Tableau Dataset and Analysis. Important domain specific metrics and data. Learn how to visualize important metrics. Show outliers and insightful data points. Download the Tableau Packaged (.twbx) Workbook. Includes comprehensive analysis of Insurance data of a large sample population. Uses industry standard analytical practices.

Tableau Practice Test

The best Tableau practice exams built. Period. Explore definitive practical problems created by brilliant Tableau experts.

Get in Touch

Contact Us
Write for Us

Published by Rahul Bhattacharya

Rahul is a journalist with expertise in researching a variety of topics and writing engaging contents. He is also a data analyst and an expert in visualizing business scenarios using data science. Rahul is skilled in a number of programming languages and data analysis tools. When he is not busy writing, Rahul can be found somewhere in the Appalachian trails or in an ethnic restaurant in Chicago.

Leave a Reply