5 Replies Latest reply on Aug 18, 2016 8:31 AM by Yuriy Fal

# Addition of 2 line graphs in a 3rd line graph?

Hello, I am new to Tableau and I am trying to plot my data around for my boss. I have just started learning it and stuck with what seems like a daunting task.

I have 2 line graphs - lets say Profit from X & Profit from Y over the past year.

I need to plot an additional Total Profit line graph in the same worksheet. In the end, I want 3 line graphs - Profit from X, Profit from Y, and Total Profit.

Can anyone please help me with this?

Few other details:

Using Tableau 9.3

I have total 10 items listed, of which 4 items form group X and rest 6 items form group Y. I have used "group members" method to form these groups.

• ###### 1. Re: Addition of 2 line graphs in a 3rd line graph?

Hi Sagar,

It looks like your question is lost in the Crow's Nest :-)

If I understand it correctly, you would like to show 3 lines on one chart.

Should they share the same screen space (a Pane in Tableau definitions)?

If yes, then -- taking into account Groups and Totals -- Dual Axis could help.

Please find the attached as an example.

If this is not what you're looking for, please reply.

Yours,

Yuri

• ###### 2. Re: Addition of 2 line graphs in a 3rd line graph?

Hi Yuri,

Thank you for your reply. Yes - this question was lost and forgotten. Thanks for bringing it back (to my memories? )

The challenge I have here is that once I group the members of the set into 2 distinct groups - X & Y - I no more have access to those members to create a group for "Total" calculations.

I will try to put a sample data and workbook to show my work over the weekend, but I am unable to see your attachment. Could you please attach it again?

Thanks,

Sagar

• ###### 3. Re: Addition of 2 line graphs in a 3rd line graph?

Hi Sagar,

It looks like you're viewing my reply in your email app.

If you click a link "View the full discussion" and open it in a browser,

could you see the clip and the name Dual_Axis_101_YF.twbx in the lower left?

This is how attachment looks like in Forums.

Yours,

Yuri

• ###### 4. Re: Addition of 2 line graphs in a 3rd line graph?

Hi Yuriy - Thank you so much! This is exactly what I was looking for. I tried it myself once and was able to do it. I have just 1 question - how do I hide / remove the axis on the right hand side?

• ###### 5. Re: Addition of 2 line graphs in a 3rd line graph?

Hi Sagar,

Right-click on the (Right) Axis and clear "Show Header" flag.

Yours,

Yuri

1 of 1 people found this helpful