
1. Re: Radial chart starting position trouble
Ken Flerlage Feb 18, 2019 6:32 AM (in response to Sue Grist)Okay, so the first issue is your multplier in SG Angle in Degrees. Since you have 53 points, each angle will be spaced 360 degrees/53 which is 6.79245 degrees. So, you'll need to adjust that calculation. That will get us to a point where the bars are aligned a bit better:
But we still have a couple of problems. I know you want to put week 1 at the top then go around clockwise, but to do that, I'd suggest we first get week one to appear at 0 degrees (where week 53 is currently) as that will make it easier for us to rotate it 90 degrees counterclockwise. To do that, change your formulas in the SD Angle in Degrees field (in Excel) to "=(A21)*6.79245283018867" then drag it down to all the rows.
Week 1 will now show 0 degrees. Week 2 will show 6.79, etc.
Okay, so now week 1 is at 0 degrees. Next we'll want to basically rotate it counterclockwise 90 degrees in order to have week 1 at the top. To do that, adjust the Angle calculation in Excel to "=90(A21)*6.79245283018867". Note: This will result in some negative degree values for some of your angles, but that's okay. 270 degrees, for example, is the same as 90 degrees.
With that adjustment, you should now have the placement you need:
Does that make sense?
I've attached the workbook and the spreadsheet.

2. Re: Radial chart starting position trouble
Sue Grist Feb 18, 2019 6:39 AM (in response to Ken Flerlage)Ken,
WOW! Thank you for your quick, thoughtful, and really well explained help with this.
Sue

3. Re: Radial chart starting position trouble
Ken Flerlage Feb 18, 2019 6:52 AM (in response to Sue Grist)Any time Sue!!