Change the plotting order of categories, values, or data series
To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis. Click a chart. This displays the Chart Tools.
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 alignment of all levels of labels.
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) axis. The scale of the secondary vertical axis shows the values for the associated data series.
Show scroll bars in Word or Excel - Microsoft Support
Scroll bars might be manually hidden. You can change this setting to show the scroll bars instead. Click File > Options. On the Advanced tab, scroll to the Display section. Select Show horizontal scroll bar and Show vertical scroll bar, and then click OK. Scroll bars might be set to automatically hide themselves. You can turn this setting off.
Edit titles or data labels in a chart - Microsoft Support
In PivotChart reports, the following procedures reestablish links between data labels and source data (not worksheet cells). On a chart, click the chart or axis title that you want to link to a corresponding worksheet cell. On the worksheet, click in …
Add or remove titles in a chart - Microsoft Support
In the chart, select the "Chart Title" box and type in a title. Select the + sign to the top-right of the chart. Select the arrow next to Chart Title. Select Centered Overlay to lay the title over the chart, or More Options for additional choices. Right-click the chart title to format it with options like Fill or Outline. Remove a chart title.
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 direction, end style of the error bars, or create custom error bars.
Change the placement of titles in a chart - Microsoft Support
To align text, in the Vertical alignment box, click the option that you want. Note: Changes to vertical alignment will not change the position of the title on the page and will only have an effect if your title contains more than one line.
Change axis labels in a chart - Microsoft Support
To change the format of numbers on the value axis: Right-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 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) axis, also known as the y axis, of the chart.
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.