Get Rid of Extra Data Points on a Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1708241%22%20slang%3D%22en-US%22%3EGet%20Rid%20of%20Extra%20Data%20Points%20on%20a%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1708241%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20I%20am%20making%20a%20graph%20and%20it%20is%20suppose%20to%20show%20sales%20data%20for%20each%20week%20(Wednesday%20to%20Wednesday)%20and%20so%20I%20have%20the%20data%20as%209%2F2%2C%209%2F9%2C%209%2F16%2C%20etc.%26nbsp%3B%20But%20for%20some%20reason%20the%20data%20on%20the%20horizontal%20axis%20is%20showing%20every%20date...%209%2F3%2C%209%2F4%2C%209%2F5%20etc.%26nbsp%3B%20How%20can%20I%20change%20it%20to%20only%20show%20the%20week%20ending%20date%20and%20not%20all%20the%20days%20in%20between%3F%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1708241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1708363%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Rid%20of%20Extra%20Data%20Points%20on%20a%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1708363%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780362%22%20target%3D%22_blank%22%3E%40DZarc9820%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDouble-click%20any%20of%20the%20x-axis%20labels%20to%20activate%20the%20Format%20Axis%20task%20pane.%3C%2FP%3E%0A%3CP%3EUnder%20Units%2C%20change%20the%20Major%20Unit%20to%207%20(since%207%20days%20%3D%201%20week).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3540.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221821i9E8D7C9FC459D848%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3540.png%22%20alt%3D%22S3540.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello!  I am making a graph and it is suppose to show sales data for each week (Wednesday to Wednesday) and so I have the data as 9/2, 9/9, 9/16, etc.  But for some reason the data on the horizontal axis is showing every date... 9/3, 9/4, 9/5 etc.  How can I change it to only show the week ending date and not all the days in between?? 

Thanks in advance! 

1 Reply
Highlighted

@DZarc9820 

Double-click any of the x-axis labels to activate the Format Axis task pane.

Under Units, change the Major Unit to 7 (since 7 days = 1 week).

 

S3540.png

 

See the attached version.