It is not possible in Tableau to dual axis 3 graphs. (Dual Axes )
But you can work around this issue by using a reference line to show the target for all the bar charts.
An example I created in the workbook attached is the following:
I created a bar chart
Added the target as a reference line
Added the profit with dual axis
Hope this helps!
Example.twbx 7.0 MB
Thank you for your reply!
Yes, this is the same solution I'm implementing, but user was trying to replicate same diagram from Excel. If this is not possible by technical design, I'm relieved.
Thank you! I now know that it's not possible by design.
While I (100%) agree with Matthias/Alexander that a bullet-style chart is a much better way to visualise this (looks like you also agree by your "relief"!)...I can't resist the phrase
this is not possible by technical design
Although not quite the arrows in your Excel, how about this....
To do this I brought profit onto the label shelf, for the line chart...and used the Difference Quick-Table calculation, to bring back the Month on Month Difference for each Month. I then used the custom formatting of that measure as per the below (▲;▼;►)
and then also changed the font to a 'equal spaced' font (such as Segoe UI), so they are all truly centered.
IMHO, my Viz is just as an 'intellectual' exercise on using all the tricks at our disposal to solve a problem, and is not an improvement on the versions Matthias/Alexander have posted. If it's easier I'd go back to the boss/client and say "Yeah, unfortunately this isn't possible in Tableau"!!...and hide this thread!!!
1 of 1 people found this helpful
thanks Alexander!...there's loads of cool shapes in the Ascii set, so as long as you set some field to be either +ve, -ve, or zero it gives just that one extra level! (...and although seems less of an issue these days, they never break when changing data-sources!!)
I have to agree with Alexander.
That custom format with arrows is cute!