Change Display Of Chart Axes. This uses a combination of. Right-click the axis you want to format and click Axis Properties to change values for the axis text numeric and date formats major and minor tick marks auto-fitting for labels and the thickness color and style of the axis line.
On the Design tab click the down arrow next to Add chart elements and then hover over Axes in the fly-out menu. To learn how to change vertical axis values we should follow almost similar steps as in the example above. Right click at the axis you want to format its labels as thousandsmillions select Format Axis in the context menu.
Right-click the axis you want to format and click Axis Properties to change values for the axis text numeric and date formats major and minor tick marks auto-fitting for labels and the thickness color and style of the axis line.
Right click at the axis you want to format its labels as thousandsmillions select Format Axis in the context menu. Right-click the axis you want to format and click Axis Properties to change values for the axis text numeric and date formats major and minor tick marks auto-fitting for labels and the thickness color and style of the axis line. You can also type the reference to the worksheet cell in the formula bar. Right click at the axis you want to format its labels as thousandsmillions select Format Axis in the context menu.