Change the scale of the vertical (value) axis in a chart
WEBBy 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
WEBYou can change the alignment of axis labels on both horizontal (category) and vertical (value) axes. When you have multiple-level category labels in your chart, you can change the alignment of all levels of labels.
Add or remove a secondary axis in a chart in Excel
WEBAdd 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.
Change the plotting order of categories, values, or data series
WEBReverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
Change how rows and columns of data are plotted in a chart
WEBAfter you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis. However, you can quickly change the way that worksheet rows and columns are plotted in the chart by switching rows to columns or vice versa.
Present your data in a column chart - Microsoft Support
WEBColumn charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.
Change the scale of the depth (series) axis in a chart
WEBA 3-D column, 3-D cone, or 3-D pyramid chart has a depth (series) axis, also known as the z axis, that you can change. You can specify the interval between tick marks and axis labels, change their placement along the axis, and reverse the …
Change the plotting order of categories, values, or data series
WEBReverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
Change axis labels in a chart - Microsoft Support
WEBRight-click the value axis labels you want to format. Click Format Axis. In the Format Axis pane, click Number. Tip: If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the vertical axis on the left). Choose the number format options you want.
Change axis labels in a chart in Office - Microsoft Support
WEBRight-click the value axis labels you want to format, and then select Format Axis. In the Format Axis pane, select Number . Tip: If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the vertical axis on the left).
Available chart types in Office - Microsoft Support
WEBLine charts can display continuous data over time, set against a common scale, and are therefore ideal to show trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis.
Skip to content