5 Replies Latest reply on Aug 12, 2016 8:02 AM by laura.winger.0

# Side-by-side bar graph with 3rd measure as different mark type

I have a side-by-side bar graph that's showing two distinct currency values. I would like to plot a 3rd measure as a circle (hopefully centered over top of the two bars in each column) which is going to show a percentage. Is it possible to do this - have two measures as a bar graph and the third as a circle mark while maintaining the side-by-side graph? Whenever I try to add the 3rd measure in, it goes in as another bar. I was looking around the forums and saw that it might be possible if the third measure is a line.

Hoping for something like this, but with the side-by-side

• ###### 1. Re: Side-by-side bar graph with 3rd measure as different mark type

you can do this by adding the creating Dual axis chart.

Below is the link showing how to create dual axis charts:

• ###### 2. Re: Side-by-side bar graph with 3rd measure as different mark type

Thanks, that did work. However, the circle takes up its own space in the graph, and my graph is already very wide to begin with. Is it possible for the circle to overlap the two bars? And if not, can I at least arrange the measures so that the circle is in the middle? Seems like it can only be in the first or third position.

• ###### 3. Re: Side-by-side bar graph with 3rd measure as different mark type

Knowing Tableau, it is probably possible, but is it worth the effort!

Perhaps trying a view like this may be a simple solution that conveys the same message:

1 of 1 people found this helpful
• ###### 4. Re: Side-by-side bar graph with 3rd measure as different mark type

Good point, I considered the idea of placing individual shapes/text boxes, but I've been doing that enough in another project!

I really like this alternate option...let me give it a try.

• ###### 5. Re: Side-by-side bar graph with 3rd measure as different mark type

I don't think dual axis will work with a side by side bar. The line chart on top won't work because of the measure names field being used, and you would be drawing a line across discreet data that had no relations ship. It would be misleading.

I think Ryan Grojean's solution is pretty good and probably a better option.