Dot Plot - Custom visualisation

[dadb25]

Hello community,

I want to create a Dot Plot , with this visualisation :

Is it possible to build these 4 colored areas ?

Thanks for your help

Regards

[bolfri · Accepted solution]

It's a math ^.^ I've created this one with 12 data points. If you will create more data points, it will look more natural.

The standard equation of a circle is:

(x - h)^2 + (y - k)^2 = r^2

Where (h, k) is the center of the circle and r is the radius.

So, if you know the values of x, h, k, and r, you can calculate the value of y.

y = sqrt(r^2 - (x - h)^2) + k

Blue	0,25	2,9895651858
Blue	0,5	2,9580398915
Blue	1	2,8284271247
Blue	1,25	2,7271780287
Blue	1,5	2,5980762114
Blue	1,75	2,4366985862
Blue	2	2,2360679775
Blue	2,25	1,9843134833
Blue	2,5	1,6583123952
Blue	2,75	1,1989578808
Blue	3	0

[MAwwad]

1. To create the four colored areas, you will need a field to group the data by. Drag and drop that field in the "Color" section of the "Visualizations" pane.
2. Adjust the formatting of the visualization and the axis as desired.

By using the "Color" section of the visualization and a field that separates the data in 4 different groups, you can create the 4 colored areas. As always it is important that your data is well prepared to match this format.

You can also use other visualization types such as Scatter chart with that format, but keep in mind that the dot plot will be more appropriate if you have a large number of data points and you want to show the distribution of values within a group.

[dadb25]

Thanks for your reply,

For the straight lines, I think I can build the field, but I'm wondering for the circle bow 🤐 . Do you have any clue how to handle that ?

Kind regards