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 »


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.

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.

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.

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.
First Working Day of the Quarter
Get the Tableau Workbook identifying the First Working Day of any Quarter of a Year.

By the Editorial Team
Tableau Practice Test
The best Tableau practice exams built. Period. Explore definitive practical problems created by brilliant Tableau experts.