Following getting some help on a previous question Old Quesiton
I thought I had it all sorted and closed the question however I've now discovered an issue I didn't anticipate.
As can be seen in the attached Excel workbook. I have donut chart showing the positions of some curtains on a circular track. There are 4 curtains on an outer track and one curtain on an inner track. In the example the curtains all move about 5 times so there are 5 groups of numbers and charts
The columns are:-
A - The Label of the points of each curtain (a startting point and ending point for each curtain).
B - The colour of the curtain
C - The position of the point. This is essentially in degrees with trailing 00's with 0 at the top centre. This number can be negative or multiple rotations
D- I was trying to break the figure in C into a single rotation of a circle in degrees thinking this may help
E - The segment size for the donut chart
So the rows with values only in col E are the remainder of a 360 circle not taken up by the segments with curtains.
My issue comes in that Im getting lost with negative values or anything more complicated than the curtains being in the 1st rotation.