excel chart date displaying in daily instead of weekly

Question

I have 2 sets of date to display on my excel histogram chart. However the dates which are on the x-axis will tend to display dates in daily sequence - even though i only have data on a weekly basis. How do i remove the dates that are irrelevant here?

Answer 1

Try the following:

1. Hover over the x-axis, right-click, and select Format Axis
2. In the dialog box select the Scale tab
3. Adjust the Major Unit input to 7 days

Answer 2

Change the axis from "Automatic" or "Date" or "Time" to "Text" or "Category" (nomenclature varies with Excel version).

In Excel 2007 or 2010 it's on the main screen of the Format Axis dialog. In Excel 2003 and earlier, you need to go to Chart menu > Chart Options > Axes.