Change the display of chart axes - Microsoft Support
You 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 …
Change the plotting order of categories, values, or data series
To change the plotting order of values, click the vertical (value) axis. Click a chart. This displays the Chart Tools. Under Chart Tools, on the Format tab, in the Current Selection group, click …
Change how rows and columns of data are plotted in a chart
For example, if rows of data are displayed on the horizontal (category) axis, but you want them to be displayed on the vertical (value) axis instead, you can switch rows to columns so that the …
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 …
Present your data in a column chart - Microsoft Support
Column 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 …
Show scroll bars in Word or Excel - Microsoft Support
On the Title bar in Word or Excel, click Word or Excel. Click Preferences , and then click View . Select Horizontal scroll bar and Vertical scroll bar and then close the dialog.
Add or remove a secondary axis in a chart in Excel - Microsoft …
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) …
Hide or display scroll bars in a workbook - Microsoft Support
Click Options, and then click the Advanced category. Under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box …
Add, change, or remove error bars in a chart - Microsoft Support
Pick More Options to set your own error bar amounts, and then under Vertical Error Bar or Horizontal Error Bar, choose the options you want. This is also where you can change the …
Change the scale of the horizontal (category) axis in a chart
The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) …
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 …