You can customize axis labels by selecting the chart, right-clicking on the axis you want to modify, and choosing "Format Axis." From there, you can adjust the label options. Here's an example code snippet to customize the X-axis labels in VBA:
ActiveChart.Axes(xlCategory, xlPrimary).TickLabels.NumberFormat = "0%" ' Customize X-axis labels as percentages