The closest I could get the desired view was to use the Automatic option and changing the range of the entire axis to be closer to the lowest value as opposed to 0.
One option may be to use a background image with the desired look and then plot the lines on top of it within Tableau. The following links give more information on background images:
Hope this helps!
(Hi Tracy! Great talking/meeting you at #TCC12.)
That's interesting, I worked on this a bit this morning (just long enough to realize it's probably not doable in T), and it never occurred to me to use the bg image trick. The logarithmic scale is going to present a bit of a hassle, but he can probably get it to work.
Tom if you decide to try this solution, and you get it close, I'll be happy to polish it up for you (i.e. getting the scales to match up).
1 of 1 people found this helpful
One other option that is even more of a hack than using a custom image background would be to generate two points for each of the gridlines, where Value = the Y value and Month Num = 0 or 50, respectively, then UNION the grideline data to the original data set and plot it along with the other data, and set the color as desired. You'd need to play with the Z-order of the marks (by sorting the colors) and might need to use a custom color legend to hide the grid color.
However, this would not solve the problem of which tick marks get labeled.
If he sets it up as a dual axis he should be able to label the ticks like he wants, then use the other axis to put in the lines you're having him draw, and hide that header. Right?
Wow, I love this fast response - thanks guys!
I'll try Jonathan's 'even hackier' idea next, just to work on some Tableau skills (they're lacking anyway, but after TTC, I'm totally inspired!)
Thanks again for everyone's input! It's seriously appreciated.