Forum Discussion
Get Rid of Extra Data Points on a Chart
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 ...
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).
See the attached version.