I have reattached your workbook (refer to Sheet 9). I used a dual axis, duplicating the Y Axis. Then, right click and select Mark Type-->Circle. Edit the Table Calculation for the second Y Axis and click OK. Then, toggle to Y Axis (2) on the marks card. Move the size slider as low as it can go. Create a calculation that finds the desired label and place it on the Label shelf. Then, you'll have to manually move the mark labels and remove the extra mark labels.
I hope this helps!
Mekko Light Complete.twbx.zip 149.4 KB
It worked well, thanks .
I actually tried to do the same thing for the X Axis, in order to add the growth between the two years beneath the values, but I faced some issues:
- When I duplicate my X axis and select "Dual Axis", Tableau does not add X axis (2) in the mark card. I'm therefore unable to chose the mark type, as you explained for the Y axis, neither the label (Which in this case I would like to be the growth). I tried to add a new Y axis too, but it seems like "Tri Axis" Work is not yet included in Tableau .
- Nothing to do with the actual subject, but when i print my work, the lines do not appear. I tried formatting the borders in the format section, but it doesn't help.
- the latest tableau file, with the "Growth" added (see sheet 11)
- What I'm trying to achieve (see slide 2 for what, thanks to your help, i'm already able to do)
- A pdf print, to illustrate my printing issue.
As you've discovered, there currently is no way to have multiple mark types when both the Y and X want to be dual axes. Also, there is no way to add a third axis. This might be something you would want to post under the Ideas section of Community.
In terms of getting the borders to print on your PDF, one possible option is to select the drop down menu next to Color on the marks card, select Border and then choose your color. If this does not resolve that issue, send a request to email@example.com. Hope this helps!
As you've discovered, there currently is no way to have multiple mark types when both the Y and X want to be dual axes.
Hubert, if this is what you're looking for the idea is already posted here: http://community.tableau.com/ideas/1087