MS Graph: Modifying The Vertical Axis

Article translations Article translations
Article ID: 62807 - View products that this article applies to.
This article was previously published under Q62807
Expand all | Collapse all

On This Page

SUMMARY

In Microsoft Graph, a scale on an axis is like the measurements on a ruler. The scale determines the range of numeric values to be plotted on the axis and the size of the interval between each tick mark on the axis. You can modify the scale of the vertical axis for area, column, and line charts. For bar charts, you modify the scale of the horizontal axis. Since scatter charts plot numeric values on both axes, you can modify both of them.

You can modify the vertical axis in the following ways:

  • Change its scale.
  • Change its position.
  • Change its text font size and style.
  • Modify its tick labels.

MORE INFORMATION

Graph 5.0

In Graph 5.0, use the following steps to change the scale, position, font size and style, and/or tick labels:

  1. Select the axis you want to reformat.
  2. From the Format menu, choose Selected Axis.

    A tabbed dialog box appears in which you can choose to format the Patterns, Scale, Font, Number, or Alignment.
  3. In this dialog box, specify the settings you want and choose OK.

Graph 3.0

In Graph 3.0, use the following steps to change the scale, position, font size and style, and/or tick labels:

  1. Select the axis you want to reformat.
  2. From the Format menu, choose Pattern.

    A dialog box appears that contains buttons for Font, Text, and Scale, and radio buttons for formatting the axis and tick marks.
  3. In this dialog box, specify the settings you want and choose OK.

Graph 1.0 and 2.0

To change axis settings in Graph versions 1.0 and 2.0, use the procedures outlined below.

Change Scale

To change the scale of the vertical axis, follow these steps:

  1. Make the Chart window active.
  2. Choose Vertical Axis from the Format menu.
  3. Enter a number for the minimum value, usually 0. (This number will appear at the bottom of the vertical axis.)
  4. Enter a number for the maximum value, usually 100. (This number appears at the top of the vertical axis.)
  5. Enter a number for the major unit. (This number represents the increments between major tick marks.)
  6. Enter a number for the minor unit. (This number represents the increments between minor tick marks. Numbers do not appear next to minor tick marks.)
  7. Click OK.

Change Position

You can move the position of the vertical axis in relation to the horizontal axis and vice versa. For example, if you are plotting some negative values, you will want the horizontal axis to cross the vertical axis at zero.

To change the position of the vertical axis, follow these steps:

  1. Make the Chart window active.
  2. Choose Vertical Axis from the Format menu.
  3. You now have three options for the position of the vertical axis.

    1. Click Right to move the vertical axis to the right side of the chart.
    2. Click Left to move the vertical axis to the left side of the chart.
    3. Click Crosses Horizontal Axis at Point, and then enter the number of the label on the horizontal axis where you want the vertical axis to cross it.
  4. Click OK.

Change Font and Style

To change the text font and style, follow these steps:

  1. Select the vertical axis by clicking on it.
  2. Choose Font from the Format menu.
  3. Click on the font type, size, style, and color you like.
  4. Click OK.

Modify Tick Labels

Tick labels are labels that appear next to the tick marks on both axes. The numbers along the vertical axis of the default column chart are its tick labels (or values).

To hide tick labels along the vertical axis, follow these steps:

  1. Make the Chart window active.
  2. Choose Vertical Axis from the Format menu.
  3. Uncheck the box next to Show Tick Labels.
To change tick labels for bar charts, enter the changes in the datasheet. Whatever is displayed in the datasheet is reflected in the chart.

Properties

Article ID: 62807 - Last Review: August 16, 2005 - Revision: 2.1
APPLIES TO
  • Microsoft Graph
  • Microsoft Graph 3.0
  • Microsoft Graph 5.0
Keywords: 
KB62807
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com