Browse » Home
Friday, July 22, 2011
How to Change the Vertical Axis Numbers on an Excel Bar Chart
Using Chart Tools
1. Click on the vertical axis numbers on the chart area. This action opens a selection box.
2. Click on the 'Layout' tab under 'Chart Tools.'
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. Press 'Close.' Excel will automatically update the graph with the new numbers.
Manual Change
5. 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.
6. Enter the number into the cell.
7. Press 'Enter.' Excel automatically updates the chart for you.