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


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.

Using Chart Tools

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

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

  • 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.

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

Manual Change

  • 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.

  • Enter the number into the cell.

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

Tips & 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.

Related Searches

  • Photo Credit Siri Stafford/Digital Vision/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!