Jun 29 2022 05:04 AM
Hi,
for my bachelor's thesis I need to visualize circumferential positions on a ring.
More precisely:
I have a number of components that need to be placed on a large ring. I have got the circumferential positions of those compnents. Now what I am looking for is a visualization that shows a ring and where those components are placed on said ring, at best with their degree numbers and a scale one the ring itself.
I hope I have explained it in a way that you can understand it. If not, please tell me what is unclear.
Thanks for your help in advance! Looking forward to your ideas.
Best
Adrian
Jun 29 2022 05:30 AM
Solution@adrianb99 I don't know that Excel is the best option for this. Is this a 1 time thing? or do you need to be able to easily feed a set of coordinates and have the graphic update? The closest to a built-in functionality in Excel (i.e. not write a macro/VBA to create this) might be the doughnut graph:
Jun 29 2022 05:53 AM
Jun 29 2022 09:02 AM
@adrianb99 Ok so i thought I'd have some fun with this and came up with this:
It lets you enter the nominal position (degrees) for each object, the size of the object (degrees) and then through this following formula calculates the 'gaps' and object sizes accordingly.
=LET(names,C2:C7,pos,A2:A7,sizes,B2:B7,start,MIN(pos-sizes/2),end,MAX(pos+sizes/2),IF((start<0)+(end>360),"Obj Position + 1/2 Size must always be between 0 and 360",
LET(cc,2*ROWS(pos)-1+(start>0)+(end<360),
s, SEQUENCE(cc),
ss,INT(SEQUENCE(cc,1,1+(start=0)/2,0.5)),
namelist,CHOOSE(MOD(s+(start>0),2)+1," ",INDEX(names,ss)),
posList,CHOOSE(IF(s=cc,3,MOD(s+(start>0),2)+1),INDEX(pos,ss)-INDEX(sizes,ss)/2,INDEX(pos,ss)+INDEX(sizes,ss)/2,360),
valList,posList-IF(s>1,INDEX(posList,s-1),0),
out, MAKEARRAY(cc,3,LAMBDA(r,c,CHOOSE(c,INDEX(namelist,r),INDEX(valList,r),INDEX(posList,r)))),
out
))
)
Jul 06 2022 08:21 AM
Jul 06 2022 08:51 AM
Jun 29 2022 05:30 AM
Solution@adrianb99 I don't know that Excel is the best option for this. Is this a 1 time thing? or do you need to be able to easily feed a set of coordinates and have the graphic update? The closest to a built-in functionality in Excel (i.e. not write a macro/VBA to create this) might be the doughnut graph: