How to Change the Vertical Axis Numbers on an Excel Bar Chart

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is spreadsheet software that helps you to create professional looking, dynamic charts and graphs. A bar graph is a type of graph that has bars to represent the data; it has a horizontal axis along the bottom and a vertical axis along the edge. Excel's Chart Tools allows you to change many aspects of the bar graph (including changing the vertical axis number intervals) with the click of a button. You can also change the vertical axis numbers manually from within the worksheet.

Skill level:


  1. 1

    Click on the vertical axis numbers on the chart area. This action opens a selection box.

  2. 2

    Click on the "Layout" tab under "Chart Tools."

  3. 3

    Choose "Axes->Axes->Primary Vertical Axis->More Primary Vertical Axis Options." Choose the factor you would like to change. For example, if you want to change the interval between tick marks to 100, write "100" in the top box.

  4. 4

    Press "Close." Excel will automatically update the graph with the new numbers.

  1. 1

    Click on the number you want to change in the Excel worksheet (not on the graph). For example, if you want to change a vertical axis number from 2,000 to 2,001 on the chart, click on "2,000" cell on the worksheet.

  2. 2

    Enter the number into the cell.

  3. 3

    Press "Enter." Excel automatically updates the chart for you.

Tips and warnings

  • Instead of clicking through the menus under the layout tab, click on the "Format Selection" option in the "Current Selection" tab to the left of the ribbon (the toolbar). This opens the "Format Axis" options box.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.