A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi,
Select the chart >> Chart Design >> Change Chart Type >> Line with Markers.
Right-click the X-axis >> Format Axis >> Axis Options >> Date axis.
Keep Base unit as Days, set Minimum to 1/1/2006, and Major unit to 6 Months.