1 2 Previous Next 17 Replies Latest reply on May 10, 2018 12:15 AM by Karthikeyan Masialamani

# Fruits - Display in Circular

All,

I just tried to display 10 fruit pictures in a circle ( may be circular way).

My excel sheet has 3 columns, fruit_name, x, y. Note, I just defined the value for x & y ( without knowing what needs to be set)

I didn't get the expected result. Herewith I attached the workbook, help is much appreciated.

• ###### 1. Re: Fruits - Display in Circular

Hi, Karthikeyan

Create two calculation fields for x, y

and the result

Hope this helps

ZZ

• ###### 2. Re: Fruits - Display in Circular

Hi Karthikeyan,

To display images around a circle, you will need to know the equation of a circle. This will determine the values of X and Y. You will have to decide on what the default size (radius) of the circle will be. Then depending on the number of images decide on how and where to place them on the circle. The link below will give you what yo need to get started.

Hope this helps

Ossai

• ###### 3. Re: Fruits - Display in Circular

The link seems good, I will read it and try to implement the same tomorrow morning.

• ###### 4. Re: Fruits - Display in Circular

Zhouyi,

It would be great if you can explain, why you used COS() for X and SIN() forY.

Why 36? why not other numbers?

why 2? why not other numbers?

Incase If i define X & Y something below (for 3 images), is it necessary to use those 2 calculated fields?

X  Y

0  5

2  4

4  2

5  0

Again, is it mandatory to use these fields wherever we would like to draw CIRCULAR report?

• ###### 5. Re: Fruits - Display in Circular

Remember your Geometry days Karthik.

Equation for a circle is X^2 + Y^2 = R^2.

X,Y coordinates on a circle can be derived by the following:

• ###### 6. Re: Fruits - Display in Circular

Hi, Karthikeyan

Hopefully this works for you.

To your question, this is the calculation for a radial point, so using cos() and sin() is the formula and assumption is the centre point is wiht (0,0), and then the number 2 is the radius, you can change to whatever number suits your case. and the last part is the number for angle, in your initial statement, you said you have 10 fruit, so I am just being lazy to you 360/10, while in the real case, you might a bit of change of that part as below

360/({Fixed: countd([Fruit Name])}).

The other part in your data is about the X, as it is already a sequential value, so I use it directly, while if in your real case, if you just have fruit name and other measures without x,y. you need create a calculation field with Index() and computing using fruit name to get the sequential value.

Please let me know if you question.

ZZ

• ###### 7. Re: Fruits - Display in Circular

Zhouyi,

Thanks for your detailed explanation.

I am clear on the first part, but the INDEX() part is not clear for me.

1) Incase If I have 20 fruits then 360/20. Right?

2) If I want to increase the image size from the current one ( bit zoom than the current size), how should i do in the current one, not changing any X,Y values, COS(), SIN() values?

3) Incase If I didn't share the X & Y value and gave only the fruit names, how do you derive X,Y ?

4) It may be the repeat question, I would like to draw this circle for 'N' fruits without knowing X,Y (N may be 10 or 20 or anything), If I have 30 fruits then the circle should be bit big and for 10 should be less, basically the circle size needs to be auto adjusted based on the fruits count.

5) Can I keep any one fruit in the centre, not using another image object and placing in the center of this fruits, Because If i have 30 fruits and If I place a seperate image object then the placement of this image object may vary if i have 10 fruits. Again, Looking for some method ( instead of adding a image object in the dashboard to keep something in the middle of this circle)

to keep a fruit ( based on user filter) in the middle of the circle. Is it possible?

Please let me know.

• ###### 8. Re: Fruits - Display in Circular

Hi, Karthikeyan

Please find the sample workbook by using index

Updates: a better version adjust the position

ZZ

• ###### 9. Re: Fruits - Display in Circular

Hi Zhouyi,

Thanks, Can you also answer for my rest of the questions? I mean 2,4,5.

One more thing, I can see 0.0, 0.5, 1 in your axis.

I didn't do any changes in your attached file, I just opened it in 10.5 version, I can see 0,1,2 .

0.5 , 1.5 is missing. is there any changes that I need to do ?

• ###### 10. Re: Fruits - Display in Circular

Hi, Karthikeyan

question 2 and 4

5 you need a bit of change, but i think it should straight forward. please find the attached workbook

ZZ

• ###### 11. Re: Fruits - Display in Circular

Everything comes as expected except the below one.

------------------------------------------------------------------

One more thing, I can see 0.0, 0.5, 1 in your axis.

Again, I didn't do any changes in your attached file, I just opened it in 10.5 version, I can see 0,1,2 .

0.5 , 1.5 is missing. is there any changes that I need to do ?

------------------------------------------------------------------

is it because of 10.5 ?

• ###### 12. Re: Fruits - Display in Circular

Hi, Karthikeyan

Hope this helps.

and if my answer helps you, can you mark my answer as either helpful or correct to close the thread? thx

ZZ

• ###### 13. Re: Fruits - Display in Circular

Thanks ZZ. I changed the 'Tick Marks' as below and it is working fine now.

1 of 1 people found this helpful
• ###### 14. Re: Fruits - Display in Circular

Hi, Karthikeyan

Can you mark my answer as correct instead of your own? this is respect to people who helps you.

ZZ

1 2 Previous Next