How to draw a circle with BI tools?Quickly bookmark this!

Mondo Technology Updated on 2024-01-30

When we were kids, we all drew circles, and the easiest way to do this was to use a compass with one leg fixed at one end of the ruler scale and the other foot to the scale of the radius value. Fix the position of your feet. Rotate the end with the pencil in one circle. A circle is complete.

So how do we draw in finebi?

We know that the degree of circle is 360°, if you draw a point in each degree and connect the 360 points, is it a circle!

Solution: According to the triangle of the Xuan, cosine to get the value (tool experience).

If the unit of the parameter is degrees, multiply it180 can be converted to radians.

The formula for calculating radians is:

Suppose the coordinates of the center of a circle are (a,b) and the radius is r, then the x-coordinate of each point on the circle = a + sin(2*360 * angle) *r;Y coordinate = b + cos(2*360 * angle) *r;

If you get a circle with a center of (0,0) and a radius of 1, simplify it as:

The final result is shown:

Preparation.

Software:

finebi=6.0.11

Data: Excel generated.

The procedure is as follows:1. **Data and import.

2. Add new fields.

x-axis coordinates = sin($*pi() 180).

Y-axis coordinates = cos($*pi() 180).

3. Copy the angle and convert it to a dimension.

4. Select a combo chartLine Diagramand drag in the relevant fields.

Note:The dragged dimension fields are adjusted to the same value as a group.

5. Some beautification, remove marked points, coordinate axes.

ps:

Related Pages