There are two types of chart axes in Excel. A value axis is used to plot numeric data and is the first type. A value axis is frequently used as the vertical axis in a chart. A category axis, which generally appears as a horizontal axis, is the other primary axis type. To organise dates or text, a category axis is employed.
Axes can be displayed or hidden by clicking anywhere in the chart. The Design, Layout, and Format tabs are added to the Chart Tools. Click Axes in the Axes group on the Layout tab. Select the type of axis you want to show or hide, and then select the settings you want to use.
Then, under the Chart Design tab, click the chart. Select an axis title option under Add Chart Element > Axis Titles. In the Axis Title box, type the text.
An XY plot with the independent X variable on the vertical axis and the dependent Y variable on the horizontal axis is called a depth chart.
Make sure it's in the General or Number format. Click Text to Columns on the Data tab of the ribbon. After selecting Delimited, click Finish.