CODEWITHSUNDEEP
tableau-api
balaji rajaram
balaji rajaram

Reputation: 51

How to do two bar graph with a line chart in it in tableau

I got four columns "Hour", "Average Requests", "Weekday FTE" and "Difference in Demand Weekday".

enter image description here

and i want the resulting graph should be like this

enter image description here

I got the same template in excel but I need it in tableau. Any solution in tableau would be big help. Thanks in advance.

Upvotes: 0

Views: 3239

Answers (2)

CR7SMS
CR7SMS

Reputation: 2584

I think you are looking for a combination chart. The following link details the steps involved in creating one:

https://help.tableau.com/current/pro/desktop/en-us/qs_combo_charts.htm

Once you understand the basic concept, you can add as many measures into the chart as you want. Hope this helps.

Edit:

Adding a video link which shows multiple bar and line charts added in the same chart.

https://kb.tableau.com/articles/howto/creating-a-graph-that-combines-a-bar-chart-with-two-or-more-lines

Upvotes: 1

Bernardo
Bernardo

Reputation: 3318

Due to having multiple measures as the bars, the line portion would not be continuous as desired. I used a transparent sheet trick on a dashboard. So I layered the line chart on top of the bars. https://www.dropbox.com/s/gfq51wu2tpmsfaw/200102%20stack%20question.twbx?dl=0

https://www.tableau.com/about/blog/2018/11/express-your-data-artistry-transparent-worksheets-tableau-98807

Upvotes: 2

Related Questions