8 Replies Latest reply on Nov 2, 2018 5:37 AM by Michael Gillespie

how to merge these 4 charts?

arnab dasgupta Nov 1, 2018 11:15 AM

Hi,

I have a requirement where we need to show all parameters in dual axis, somewhat similar to the below figure, but it has to be combined so that for a nice comparative view, ie all bar charts lined up together with line graphs on same sheet. We have 5 parameters, so I guess if i can make this on 4, if I reduce the size of bars, I can get all 5 together. I am new to tableau, still learning. Please suggest if any way else I have to show in some other different way.

Thanks a lot,

Arnab

Book.twbx 1.4 MB

1. Re: how to merge these 4 charts?

Akram Ebrahim Nov 1, 2018 12:07 PM (in response to arnab dasgupta)

Hi Arnab,

is this what you are looking for?
Like Show 0 Likes(0)

Actions
2. Re: how to merge these 4 charts?

arnab dasgupta Nov 1, 2018 12:23 PM (in response to Akram Ebrahim)

Hi Akram,
thanks for replying. Yes, this looks good, but can it be like central, east, west, south be side besides for the same month? And we can get 4 lines on top.....is that possible?

Thanks,
Arnab
Like Show 0 Likes(0)

Actions
3. Re: how to merge these 4 charts?

Akram Ebrahim Nov 1, 2018 12:38 PM (in response to arnab dasgupta)

Hi Arnab,,
Is this your requirement?

If not do some mock image like how you want to see the output. Hope this helps
Like Show 0 Likes(0)

Actions
4. Re: how to merge these 4 charts?

arnab dasgupta Nov 1, 2018 1:12 PM (in response to Akram Ebrahim)

Hi Akram,
thanks a lot for all your efforts. This looks good too, but I would have liked the axis to be only one ie from Jan to december and bar's all side beside for each month. Your chart have months repeated, I wouldn't like that. Comparison becomes difficult in that case. From my chart, I want all of them to be shown together on common x axis from Jan to December and maybe profit to be shown as line on top of that. The bars look like this. Problem is drawing 4 lines on top of this for dual axis. I am just thinking of options, if its possible or not.
Like Show 0 Likes(0)

Actions
5. Re: how to merge these 4 charts?

Akram Ebrahim Nov 1, 2018 1:22 PM (in response to arnab dasgupta)

Hi Arnab

Like this?
Like Show 0 Likes(0)

Actions
6. Re: how to merge these 4 charts?

arnab dasgupta Nov 1, 2018 2:45 PM (in response to Akram Ebrahim)

Hi Akram,
please see my first chart. It will be better if there are 4 lines, each for each region, not 12 lines as above one for each month.

Thanks,
Arnab
Like Show 0 Likes(0)

Actions
7. Re: how to merge these 4 charts?

Akram Ebrahim Nov 2, 2018 2:37 AM (in response to arnab dasgupta)

Arnab,

We are splitting the graph month on month so the trend will not come as expected. Either you have to change approach or put the 4 line charts in different charts and combine them in the dashboard
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
8. Re: how to merge these 4 charts?

Michael Gillespie Nov 2, 2018 5:37 AM (in response to arnab dasgupta)

If you are using the newest release of Tableau Desktop (2018.3) we now have transparency available to us when building dashboards.

So, you might try building the bar graph as you want it, and then in a separate viz build the line graph the way you want it, then layer the line graph over the bar graph in the dashboard, making the line graph a transparent background.

That is a LOT of data to show at once in a single view, however. I would be cleaner to show the bars and lines as 2 separate entities on a single dashboard.
2 of 2 people found this helpful
Like Show 1 Likes(1)

Actions