3 Replies Latest reply on Jan 8, 2013 6:43 AM by Alex Kerin

# Axis in scatterplots (dynamic y-axis range to max x-axis)

I have a question regarding axis range. Is it possible to "lock" the axis to the maximum value of the other axis? I guess it has to be a work around but this will suffice.

I'm asking because if you have for example turnover on the x axis and contribution on the y axis then it would be helpful if the axis with the lowest amount/value dynamically synced with the the one with the largest value. The reason being that this way one would get the correct picture of the slope of the trend in the scatter plot. In this example the slope would indicate the contribution percentage.

I know this is posted as an Idea here http://community.tableau.com/ideas/1523 but there isn't a solution to the problem posted as a comment to the idea.

Any help is appreciated.

Thanks!

//Martin

• ###### 1. Re: Axis in scatterplots (dynamic y-axis range to max x-axis)

You can create a calculation that finds the max X and set that as a reference line. In the example I found I had to multiple that by 30% to get the same axes. In the attached I've left the ref line as grey, but you could set it to 0% transparency (better than white).

1 of 1 people found this helpful
• ###### 2. Re: Axis in scatterplots (dynamic y-axis range to max x-axis)

Alex you are a star. I just created a calculation that keeps the x-axes measure poped that into the level of detail shelve and set it to total using maximum. No need for multiplying.

My data source is a cube by the way which is nice to know so no need for window_max(max([measure])).

Thank you!

//Martin

• ###### 3. Re: Axis in scatterplots (dynamic y-axis range to max x-axis)

You're welcome. I just realized you don't need the window_max on any datasource because of course the ref line dialog lets you pick the max value.