It is always better to post a work book so that we dont have to waste time recreating the data (probably wrong)
Click on your chart, right click format axis > in the box on the right there are 4 icons
Fill & Line
Effect
Size and Properties
Axis Options <Click on this one> then expand Axis options
Change the Units > Major to 7 days
