How do I show text in the X-axis in Excel?

Right-click the category labels you want to change, and click Select Data.

In the Horizontal (Category) Axis Labels box, click Edit.
In the Axis label range box, enter the labels you want to use, separated by commas.

How do I customize the X-axis in Excel?

How to Change X-Axis Intervals

Open the Excel file with your graph and select it.
Right-click on the Horizontal Axis and choose Format axis.
Select Axis Options.
Under Units, click on the box next to Major and type in the interval number you want.
Close the window, and the changes will be saved.

How do I add horizontal axis labels in Excel?

Go to the Design tab from the ribbon. Click on the Add Chart Element option from the Chart Layout group. Select the Axis Titles from the menu. Select the Primary Vertical to add labels to the vertical axis, and Select the Primary Horizontal to add labels to the horizontal axis.

How do I format the horizontal axis in Excel?

Click anywhere in the chart. This displays the Chart Tools, adding the Design and Format tabs.
On the Format tab, in the Current Selection group, click the arrow in the box at the top, and then click Horizontal (Category) Axis.

How do I change the axis scale in Excel 2020?

Changing the Axis Scale

Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
Choose Format Axis from the Context menu.
Make sure Axis Options is clicked at the left of the dialog box.
Adjust the scale settings (top of the dialog box—Minimum, Maximum, etc.)
Click on OK.

Can you graph text in Excel?

Select the “Insert” tab in the Ribbon at the top of the page. Click the drop-down box for the “Column,” “Pie” or “Bar” chart type. These chart types allow number and word variables, where Line charts, Scatter charts, and Area charts require two numeric variables.

How do you add alt text to a graph?

Add alt text to a chart

Select the entire chart.
Do one of the following: Select Format > Alt Text. Right-click the chart, and select Edit Alt Text.
In the Alt Text pane, enter alt text describing the chart.