You'll need to duplicate the field on which your axis is based on and add it to your columns pane alongside original field, convert it to dual axis and make sure you sync the axes.
Once you've done that, right click your bottom axis, edit axis, delete the title. Now, right click the axis again and select format, change the font to white (or what ever the background colour of your sheet is) and change ticks to "None".
I've attached a sample workbook for info.
Hope that helps.
Book1.twbx 2.5 MB
Hi Ryan, thank you for the quick response. But I am not able to open the book you sent . I using 9.0.
Ahh, that's unfortunate.
I can breakdown the instructions in my original post in to more detail but nothing beats seeing it in action.
1) First duplicate your axis field (I'm going to assume [Sales] for this post) by right clicking on it and selecting duplicate.
2) Drag [Sales] and [Sales (Copy)] to your "Columns Shelf".
3) Right click on which ever field is on the right-hand side of your shelf and select "Dual Axis"
4) Now, you should have a horizontal axis at the top your your chart (and the bottom). Right-click the axis at the top of the page and select "Synchronize Axis".
5) Right-click on the axis at the bottom of your chart, select "Edit Axis"
6) Delete what ever it says in the "Title" box and hit ok - will either say Sales or Sales (Copy)
7) Right-click on the bottom axis again and select format - change the font colour so it's the same as your sheet background and set Ticks to none.
You now have 1 visible axis at the top of your chart, you may need to change our marks on the marks shelf.
Hope that helps.
1 of 1 people found this helpful
You can also just install both versions of Desktop on your machine -- I usually have 4-5 versions of Tableau so I can open any packaged workbook I need to. See: http://www.tableau.com/esdalt
Thank you for taking pain to guide me on this step by step. It is an incredible help as this helps my presentation sail now with respect to occupying space and formatting.
Thanks a ton Ryan
Yes Matt,I agree. But my organisation allows only one of the version is allowed to install and use my bad. I am interested in trying multiple versions at the same time to compare and see what fits for my data. I am thinking of getting a personal edition of tableau.