Format Axis In Excel. To change these values execute the following steps. Right click the x axis in the chart you want to change.
At the top of the excel window click on the layout tab. On the format tab click vertical value axis in the dropdown list and then click format pane. By default excel automatically determines the values on the vertical axis.
On the design tab click the down arrow next to add chart elements and then hover over axes in.
Format axis labels as thousands millions 1. Open the excel file with the chart you want to adjust. The axis options for formatting the vertical value axis in excel 2019 include. Use the minimum option.
