For any of the options in the Axes tab, click to format the border and background, and click to format the font.Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 More.To customize the number formatting, deselect Default Format, then click, and then customize the number format in the Format Numbers dialog box.Ĭustom Range-Enter values for Min, Max, and Step to define the starting and ending numbers and the numeric intervals of the axis.

The default format uses a comma thousands separator with no decimal places, scaling, or number prefixes or suffixes. Default Format-Select to use a standard number format for the Y-axis and secondary Y-axis when using a combo chart.

To define Custom Range on the secondary axis of a bar or line chart, enter values for Min, Max, and Step. Secondary Axis Label-Select to use a range of value on the secondary axis. Secondary Axis Title-Enter a title for the secondary axis in the chart, if there is one. For example, you can display values 40 through 60 at three step intervals by entering 40, 60, and 3 as the values for Min, Max, and Step. You can define a Custom Range to change the starting and ending numbers of your axis and the numeric intervals. Primary Axis Label-Select to use a range of values on the primary axis. Primary Axis Title-Enter a title for the primary axis in the chart.

Show Metadata Labels-Select to show metadata labels with a standard display.įinancial Reporting implements staggered labels as a default to ensure the even distribution of data on report axes. Metadata Title-Enter a title for the axis label.

Excel graph axis label increments