excel chart x axis date format. In the format axis dialog, select number. This will enable you to select the appropriate display.
excel chart x axis date format You will need to format the x axis with a date format. The format axis task pane will appear on the right side of the screen. Use a scatter (xy) chart.
The Format Axis Task Pane Will Appear On The Right Side Of The Screen.
You will need to format the x axis with a date format. This will enable you to select the appropriate display. To change the axis type to a text or date axis, expand axis options, and then under axis type, select text axis or date axis.
Expand Axis Options, And Then Under Axis Type, Make Sure Date Axis Is.
Use a scatter (xy) chart. In the format axis dialog, select number.