How to Create Dual Axis Charts in Tableau

#TableauTipTuesday: How to Create Dual-Axis (or Combination) Charts
vizwiz.blogspot.com/2015/12/du...

[@clarkegallie9132]

More than 2 years later and still super helpful. Thanks!

[@PaulBrowningtons]

Thank you for having a good microphone. Soooo many Tableau videos have horrible sound. Awesome job with this vid. Thanks for teaching.

[@dabrave]

Best Tableau videos on YT, congrats Andy, pretty concise and straight to the point!

[@juhnniemer9716]

I am so happy to have seen this video as I start on my first dual axix map. I will sure to go back here everytime I got stuck creating one. You have covered almost all applications of dual axis map in as short as 11 mins instructional video. Thanks so much. helped me a lot... like so much....

[@yuji9733]

Glad to come across your channel. Awesomely informative, practical and easy to follow. Best Tableau channel on KZbin!

[@ridhimatalwar3691]

Thank you so much Andy for this. You have taught so much in just 10-11 mins.

[@vivekshelke6458]

In a short time...you taught me a lot of new stuff... Thank you, Andy....

[@mrpennington72]

Another great video, Andy. Your tutorials are always well put together, clear and concise. Thanks for taking the time to do these!

[@vizwiz]

+Michael Pennington Thanks! The pleasure is all mine!

[@weihwachan6610]

These are outstanding examples Andy! Thank you!

[@mkforbin9451]

I am new to tableau and you make me feel at home.Keep it up Andy

[@digwijoymandal8662]

You showed I guess all probable scenarios. Thanks for sharing such a descriptive video in such a short time.

[@freakprash]

I must say I agree with Karen. You have done an excellent work... Thanks a ton

[@KPG484]

I am new to Tableau and this is by far the most useful & clear video I have seen on Dual Axis. In a sea of frustration with this tool, where there is life and Andy Kriebel, there is hope. Thank You.

[@vizwiz]

+Karen Dean Thank you very much Karen! That's very nice of you!

[@narasa12]

Excellent tableau video I had ever seen... Thank you so much

[@rafiks717]

This is quite deep session in 10 minutes 👍👍 Thank you Sir

[@Jahrhcy]

Thanks for sharing! It's very clear and succinct!

[@DilipAghav]

Thanks Andy. These examples are really very good.

[@fawadmahdi]

Great tutorial. Thank you for sharing your experience with tableau

[@zubairahmed-nt8ml]

Awesome....It is very clear & excellent...Thanks a million

[@nishantpurohit100]

Thanks for all your videos, wishing u best.

[@wabex11]

Thank you, it was very clear to follow and gave a wide idea of some useful graphics.

[@zx-25r12]

Thank you so much, i am a beginner and this is very helpful giving me ideas

[@deepakrajan2041]

Hi Andy this video was really helpful and sharing the file helps to practice and gain some real confidence on this tool

[@mickyandguitar]

Amazingly helpful. Keep uploading awesome content.

[@people_chronicles]

SIR !!! What should I call u...a Superman of Tableau or a Hulk or what...u are just AMAZING !!!

[@tmbj650]

Awesome thanks for helping out to understand dual axis charts.

[@rajup4970]

Excellent, great job could you please share the interview questions about the tableau and complicated dB as well.

[@macariohg]

Great video, Andy. ¡Thanks!

[@shalinigarg859]

Thank you. It's really informative 👍

[@ladotlacity3515]

Any suggestions on a dual axis chart with different data sources for X axis & different volumes for the Y? For example: submission date and closed date for quantity of service requests. So you have two dual axes: the top and bottom are dates for submitted and closed respectively and the left and right are the volume for submitted and closed respectively.

[@govardhanbola1195]

Hi Andy, could you please do a video on how to connect tableau using SAS datasets.

[@judypingmccormick3904]

Simply brilliant!

[@vizwiz]

Thanks Judy!!

[@ranju184]

Excellent explanation.

[@prachiwanjari1160]

thank you andy, very helpful

[@hariharjoshi8344]

thankyou for posting these

[@pramishprakash]

Great demo sir....

[@manuprakash1989]

worth watching..cheers!

[@simran19587]

Hi Andy, does the lollipop chart not work with filters? If I add a filter and let the lollipop changes for the mesures the size of the bars and circle changes from thin to fat which is not what I want. Help!!!

[@andreahartlein8043]

very good! thanks!

[@negusuworku2375]

Thank you so much. Very helpful.

[@vizwiz]

You're very welcome!

[@jigsparikh7961]

VERY HELPFUL THANKS

[@annarocha9769]

This is awesome, thanks!!

[@vizwiz]

My pleasure!

[@Zodiac65ForU]

Great explanation

[@tinhkhau6656]

Awesome. Please give us some more. Maybe on interactive dashboard. Thanks

[@manmeetkaur-ud2ti]

Hey Andy, I hope you are doing well. Thanks for making one more video. One query, I want to synchronize two different axis (% and volume) but I want to align the axis without making other axis to volume

[@vizwiz]

That doesn't make logical sense. Synchronizing means that have the same scale.

[@colleensaylor259]

I know this is old but I would love to see a demo of the dual axis chart and how to filter only one of the two axis while the other remains fixed. I am working on some data for individual counties and would like the second axis to be the state total for the measure and stay the same while I am changing the first axis to an individual county level data.

[@vizwiz]

You can used a FIXED level of detail expression for the axis that you want to remain unchanged. The other axis would change based on the filters you choose. The FIXED will not be impacted because it calculates before dimension filters in Tableau's order of operations.

[@judypingmccormick3904]

Hi Andy, for your 'lollypop' chart, if I want to put a tennis ball at the end of the bar chart, because I want to create a viz for 'Tennis GOAT - Greatest of All Time', is there an easy way to do so please. Thank you. Judy from sunny Melbourne

[@vizwiz]

Yes. Instead of using a circle for the lollipop, use a Shape mark type. Make sure you have the tennis ball in the "Shapes" folder in your My Tableau Repository. Once you do, click on the Shape shelf and choose the tennis ball.

[@judypingmccormick3904]

Excellent. Thank you 'Awesome Andy'.

[@sahiltikku6970]

How to make dual axis for 3 measure

[@NinjaGames443]

Thank You

[@nightfire4107]

Coolest software

[@paravej]

Thanks Andy

[@wonderwoman9895]

Thanks and Regards :)

[@Seraphic75]

Thanks for this. But does anyone have a link to a tutorial where the two variables are not in different columns of the dataset? I need to present two years in front of each other, so as to compare the two years month by month.

[@vizwiz]

If I understand you, you have year in one column and the values are in another and you want one year to be bars and another as a line. Show them both by month. You will need to create two calculated fields, one for each year. This will take your date column and crest two columns. For example, use this calc for each year: IF YEAR([Date]) = 2020 then Sales End Once you have the two columns, you can create the dual axis chart.

[@Seraphic75]

@@vizwiz Thank you! Also for the very speedy reply! 🙂

[@vizwiz]

I made a video that shows what I described above. kzbin.info/www/bejne/sJe2pa2CgM6fo6s

[@mayur17990]

Excellent

[@Ironboost007]

I mainly use dual axis to show the labels for the color categories and for the total, but it also has many possibilities with the design as you did. I published an ebook in Kindle called Tableau Neural Book that includes this and other 50+ tutorials for tricks from the basic to the complex. If you're a beginner I'd say you go see the topics for free, I think it will be useful for you ;)

[@burdine26.120]

Could not find Tableau in the Mac App Store.

[@LukeBeacon]

Too basic!

[@vizwiz]

+Luke Beacon what do you mean by too basic?

[@LukeBeacon]

+Andy Kriebel I guess I am just used to your more nuanced workaround videos. No worries, though, still a great vid! :)

[@vizwiz]

+Luke Beacon Gotcha! We're building a training campaign at The Info Lab and we couldn't find a good dual-axis video, so I created this one instead.

[@manuprakash1989]

worth watching..cheers!