Make Y Axis Start at 0 in Charts in Excel

Add to Favorites
Author:

How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue.

  1. Select the Chart and go to the Layout tab (that is visible only when you select a chart).
  2. Click the Axes button and go to Primary Vertical Axis and then More Primary Vertical Axis Options...

  3. You will now be in the Format Axis window.
    Look to the top and next to where it says Minimum click the circle for Fixed and enter a 0 (zero). (If your window doesn't look like this, make sure you have selected the Axis Options category from the left side of the Format Axis window)
  4. Hit Close and that's it!

Note: You can start the Y axis at any number; instead of typing a zero for step 3, input the desired number.

Notes

This is a simple yet important thing to know how to do in Excel. That is because Excel will guess what you want the starting unit to be for the Y axis and it doesn't always know what you want.

Make sure to download the Excel file that accompanies this tutorial to see this example in the spreadsheet.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Display all Formulas at Once in Excel
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...