Question: how to change date axis in excel chart?
Answer: In the chart, right-click the category axis, and then click Format Axis., In the Format Axis pane, select the Axis Options tab., Expand Axis Options, and then under Axis Type, make sure Date axis is selected., Under Units, next to Base, select Days, Months, or Years. Notes: