Why can’t I edit horizontal axis labels in Excel?

Make sure that it is formatted as General or as Number. On the Data tab of the ribbon, click Text to Columns. Select Delimited, then click Finish.

How do I customize data labels in Excel?

To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.

How do I change the horizontal axis values in Excel 2020?

Follow the steps to change date-based X-axis intervals:
  1. Open the Excel file with your graph and select it.
  2. Right-click on the Horizontal Axis and choose Format axis.
  3. Select Axis Options.
  4. Under Units, click on the box next to Major and type in the interval number you want. …
  5. Close the window, and the changes will be saved.

How do you change the axis values on Excel graphs?

How to Switch X and Y Axis
  1. Right-click on the chart and choose Select Data.
  2. Click on the button Switch Row/Column and press OK.

How do I add axis labels in Excel?

Click the chart, and then click the Chart Design tab. Click Add Chart Element > Axis Titles, and then choose an axis title option. Type the text in the Axis Title box. To format the title, select the text in the title box, and then on the Home tab, under Font, select the formatting that you want.

How do I change the bar graph layout in Excel?

Click anywhere in the chart or click the chart element that you want to change. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, do the one or more of the following: In the Labels group, click a layout option for the chart label that you want to change.

How do I change the horizontal axis in Excel?

In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements:
  1. Click anywhere in the chart. …
  2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis.