You can, however, manually adjust the tick mark spacing by dragging the middle handle. The tick mark spacing for value axes is usually calculated by think-cell.Holding down Alt while dragging ensures that the value axis scale will not revert to automatic mode. Automatic value axis scaling can be restored by dragging the handles until the tooltip indicates Automatic or selecting Reset to Automatic Scale from the contextual menu of the axis or scaled chart element. If you do not want to show a specific value, either remove it from the datasheet or hide the respective datasheet row or column. The values on the axis must always include the range between the lowest and largest value in the datasheet. You can, however, manually scale a value axis by dragging the handles at the end of the value axis. Value axes are usually scaled by think-cell.When using gridlines, select one of the gridlines to show the axis handles. When selected, a value axis has three handles, shown below both for the axis line and the gridlines representation. The X-axes of all other charts are standard category axes. In addition, the X-axis of a line chart may be a value axis, rather than a category axis (see Line chart).

Similarly, scatter and bubble charts have two value axes that are always displayed. Note: The X-axis of a Mekko chart is also a value axis. Usually the Y-axis in a chart is a value axis.

Use this feature to show a numerical scale for the values in your chart, represented either by an axis line with tick marks or by gridlines.

8.1 Scales and axes 8.2 Arrows and values 8.3 Legend 8.1 Scales and axes 8.1.1 Value axis In menu:

Excel add counter up and down arrows