How to: Format Axis Labels as Dates or Currencies - TechNet

When you show properly formatted DateTime values on an axis, a chart will automatically display these values as days.

technet.microsoft.com