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 counter-clockwise. To do that, change your formulas in the SD Angle in Degrees field (in Excel) to "=(A2-1)*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 counter-clockwise 90 degrees in order to have week 1 at the top. To do that, adjust the Angle calculation in Excel to "=90-(A2-1)*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.
WOW! Thank you for your quick, thoughtful, and really well explained help with this.
Any time Sue!!