excel图表日期显示在每日而不是每周

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?I have 2 sets of date to display on my excel hi