8 Replies Latest reply on Jul 9, 2019 2:32 PM by Carlos Carvalhar

Remove overlapping from Scatter plot graph

Hi,

That's my graph:

The problem is that I have just one point with 42 overlapping points.

How can i remove this overlapping?

I found this Jitter those points!

But it's dificult to me, as a begninner, to understand it.

I'd like to exbit all points with the same X-Y location, without overlapping.

Any suggestion?

My data:

• 1. Re: Remove overlapping from Scatter plot graph

Can you help me understand the problem?

Is it simply that the size of the overlapping is too small? I increased the size and found it quite readable.

• 2. Re: Remove overlapping from Scatter plot graph

I don't want to resize it, i'd like to show each one of the overlapping points.

Mainly because I'd like to add all labels, from every point.

This tutorial has something using jitter Jitter those points! but i couldn't replicate the effect with random points distributed trough the center.

1 of 1 people found this helpful
• 3. Re: Remove overlapping from Scatter plot graph

Hi Carlos,

There are currently 42 rows that have values of 5, 5.  If you want to jitter them, or separate them, you need to either add to them or subtract from them so they're not all on the same point.

If you change the axes from integers to decimals, you can change the 5 to 5.1 or 5.2 and jitter them a little.  You're still going to have overlap though because there are so many measures on that same point.

Best,

Paul

• 4. Re: Remove overlapping from Scatter plot graph

Is it possible to create a function in Tableau to calculate this variation?

I mean, filter those 42 and then changing a litlte the X,y coordinates?

1 of 1 people found this helpful
• 5. Re: Remove overlapping from Scatter plot graph

Hi Carlos,

It is possible to jitter these using some custom table calculations. However, I don't think jittering is the way to go for this particular view. The reason why is that on the chart as laid out depending on the screen size the available space (i.e. between 4 and 6 on the Y axis and between 4 and 6 on the X axis) is somewhere between 1-3cm on each axis. That's just too little space to put 42 distinct labels in any sort of reasonable font size. What is the purpose of trying to show all the labels? Also is this a static output or an interactive visualization? For example in the latter case a separate view might be used to show the detail of those 42 values.

Jonathan

• 6. Re: Remove overlapping from Scatter plot graph

Yeah, i gave up about all labels.

Using rand() on excel i added some fractions at the end, so i could see the points a little distant from each one.

• 7. Re: Remove overlapping from Scatter plot graph

Just a random thought, but how about creating another scatter plot inside a tooltip (viz in tooltip) focusing on the selected (hovering on) scatter plot data point and showing all the 42 data points on a more spreadout axis ? Something like this...

• 8. Re: Remove overlapping from Scatter plot graph

It's really interesting for web content, but in my case it's print and it would lose the effect.