How do I change my x-axis in Excel?

How do I change my x-axis in Excel?

Right-click the X-axis in the chart you want to change. That will allow you to edit the X-axis specifically. Then, click on Select Data. Select Edit right below the Horizontal Axis Labels tab.

How do you make a graph on Excel 2003?

Creating a chart sheet

1. Create an embedded chart.
2. Select the chart to be moved to a chart sheet.
3. Choose Chart Location from the menu bar.
4. In the Chart Location dialog box, select the As a new sheet button. (The As object in button adds the chart as an embedded object on the worksheet.)
5. Click the OK button.

How do I change the x-axis numbers?

Change Horizontal Axis Values in Excel 2016

1. Select the Chart that you have created and navigate to the Axis you want to change.
2. Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Edit.

How do I change the x and y axis values in Excel?

Click anywhere in the chart for which you want to display or hide axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Layout tab, in the Axes group, click Axes. Click the type of axis that you want to display or hide, and then click the options that you want.

How do I add a title to a chart in Excel 2003?

Adding a Chart Title

1. Click your chart to select it.
2. From the Chart menu, select Chart Options… The Chart Options dialog box appears.
3. Select the Titles tab.
4. In the Chart title text box, type the desired title.
5. Click OK. The title is now added to your chart.

How do you change chart labels in Excel?

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

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

How do I change the x-axis value to text in Excel?

Use new text for category labels in the chart and leavesource data text unchanged

1. Right-click the category labels to change, and click Select Data.
2. In Horizontal (Category) Axis Labels, click Edit.
3. In Axis label range, enter the labels you want to use, separated by commas.

How do you edit the horizontal axis data?

In the Select Data Source dialog box, under Horizontal (Categories) Axis Labels, click Edit. In the Axis label range box, do one of the following: Specify the worksheet range that you want to use as category axis labels. , and then select the range that you want to use on the worksheet.