<< Back

How do I build a Dual Axis Area Chart to add a Line Graph?

The Information Lab Ireland is the leading provider of Tableau and Alteryx training in Ireland. Last week, we looked at creating an Area Chart. We mentioned then that it had its limits and that there were ways of perhaps improving, or at least, adding to it. So this week we are going to look at one simple way of adding to it.

How do I build a Dual Axis Area Chart to add a Line Graph?

As you can see we already have our basic area chart. What we are hoping to do is add an extra line to the top of the area chart which will show the totals on a single reference line. In our Rows Shelf drag your SUM(Sales) and while holding ctrl drag the duplicate SUM(Sales) across to create another Area Chart.

You will now have to remove the Categories off Colour in the ‘new’ SUM(Sales) Marks Card. Notice how it now reverts back to a single colour and the filter has disappeared.

From the drop down menu change your Area to Line.

Back in the Marks Card you can edit colours to make the line black or whatever colour fits your style guide.

You then need to place the Line Graph on top of the original Area Chart. You do this by creating a Dual Axis from the second SUM(Sales) pill in the Rows Shelf.

You can choose to include Show Marks Labels if you wish.

Who/What is…?

The Information Lab Ireland

The Information Lab (“TIL”) is a Gold resale partner of Tableau and Alteryx and offers related consulting and training across seven territories in Europe. TIL has offices in Ireland, the UK, Germany, France, Italy, the Netherlands and Luxembourg.

Clients include Coca-Cola, Close Bros Bank, PepsiCo, Deloitte, UBS, Solar Turbines & Boston Consulting Group. The Information Lab has worked with Close Brothers Bank to support their use of Alteryx for compliance with IFRS 9.

The Information Lab Ireland is at the forefront of creating a data-driven culture in Ireland. As part of its vision, The Information Lab Ireland regularly hosts free events throughout the country to show how being data-driven can improve decision making and lead to a better understanding of the world around us.

For more on these events please like us on Facebook or follow us on Twitter

Tableau

Tableau is the gold standard for intuitive, interactive visual analytics and an established enterprise platform. Over 54,000 customers have adopted Tableau to answer more questions of their data.

Leave a Reply

Your email address will not be published. Required fields are marked *