Whimzyy

Trim() seemed to work great! Must be some weird spacing in the google sheet. Looks the same but obviously isn't. Thanks for the help!! 

Hmmm okay I get what you are saying but it still doesn't make sense lol... I have the Reps as the X axis and then the count of Reps name as the Y axis. This has been working for our other states for 6+ months but this states card keeps breaking into individual bars. 

Sorry I wasn't clear on my post. I am trying to convert week # to a shorthand date format but also add the 27 days as an interval. Thanks! 

Awesome, Thank you. I will check out the tutorial and see how it goes. I appreciate the help! Thanks!!