Change the scale of the vertical (value) axis in a chart
By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
Change the display of chart axes - Microsoft Support
You can adjust the way that they are displayed by using major and minor tick marks and labels. To eliminate clutter in a chart, you can display fewer axis labels or tick marks on the horizontal (category) axis by specifying the intervals at which you want categories to be labeled, or by specifying the number of categories that you want to ...
Add or remove a secondary axis in a chart in Excel
When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis shows the values for the associated data series.
Display or hide chart gridlines - Microsoft Support
To make the data in a chart that displays axes easier to read, you can display horizontal and vertical chart gridlines. Gridlines extend from any horizontal and vertical axes across the plot area of the chart. You can also display depth gridlines in 3-D charts.
Change the scale of the horizontal (category) axis in a chart
To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you want in the text box, or select At maximum category to specify that the vertical (value) axis cross the horizontal (category) axis ...
Change the scale of the depth (series) axis in a chart
To change the placement of the axis tick marks and labels, select any of the options that you want in the Major tick mark type, Minor tick mark type, and Axis labels boxes.
Change axis labels in a chart - Microsoft Support
In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels.
Change axis labels in a chart in Office - Microsoft Support
In charts, axis labels are shown below the horizontal (also known as category) axis, next to the vertical (also known as value) axis, and, in a 3-D chart, next to the depth axis. The chart uses text from your source data for axis labels. To change the …
Format elements of a chart - Microsoft Support
Change format of chart elements by using the Format task pane or the ribbon. You can format the chart area, plot area, data series axes, titles, data labels, and legend.
Display or hide chart gridlines - Microsoft Support
To make the data in a chart easier to read, you can display horizontal and vertical chart gridlines that extend across the plot area of the chart. You can also display depth gridlines in 3-D charts. Gridlines can be displayed for major and minor units, and they align with major and minor tick marks on the axes when those are displayed.
Change the format of data labels in a chart - Microsoft Support
Here are step-by-step instructions for the some of the most popular things you can do. If you want to know more about titles in data labels, see Edit titles or data labels in a chart. Customize the look of data labels, connecting lines, the shape of the data labels, and resizing the data labels.