Formatting Stacked Column Chart

[ejnels87]

I am trying to create a stacked column chart that details hours utilization over a rolling 52 week period. When I create the chart the x axis (date) are in the order I want them to be in when it is specified as a date axis, however the columns are stick thin. When I change the x axis to a text axis, it fixes the bar width issue, but reverses the date order. Then when I check the reverse order of data box, it put the order back to the original, but moves the y axis to the right. This causes the graphs in my dashboard to not be uniform. How can I keep the dates in the order I want, the y axis on the left, and the bars wide?

 

[awoohaw]

adjust the GAP width: