The Must include zero option applies to all chart types and enables the chart to begin measuring at a point other than zero. With this option selected, the chart axes will begin at zero, regardless of the actual starting point of the chart data. When this option is not selected, the dimension axes begin at the point closest to the actual chart data value.
To include zeros in the chart:
![]() |
You can also right-click anywhere in the chart and select Chart Options... from the right-click menu. |
When you click the Apply button the changes are implemented but the dialog box remains open.
![]() |
If the Must include zero check box is not selected, but the chart data begins at zero then the chart axes will begin at zero. |