- How do I change axis to weeks in Excel?
- How do I customize axis in Excel?
- How do I change the axis intervals in Excel?
How do I change axis to weeks in Excel?
In the chart, right-click the category axis, and then click Format Axis. In the Format Axis dialog box, select Axis Options on the left. Under Axis Type, make sure Date axis is selected. Next to Base Unit, select Fixed, and then in the list, select Days, Months, or Years.
How do I customize axis in Excel?
Click anywhere in the chart for which you want to display or hide axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Axes group, click Axes. Click the type of axis that you want to display or hide, and then click the options that you want.
How do I change the axis intervals in Excel?
To change the interval between axis labels, expand Labels, and then under Interval between labels, select Specify interval unit and type the number you want in the text box.