How do you add axis labels in Excel 2007?

How do you add axis labels in Excel 2007?

Adding an Axis Title

1. Click the chart.
2. From the Layout command tab, in the Labels group, click Axis Titles.
3. To create a title for your x-axis, select Primary Horizontal Axis Title.
4. Click the title location you desire.
5. In the Axis Title text box, type a name for the axis.
6. (Optional) To reposition your axis title,

How do I add axis labels to a scatter plot in Excel?

Click the chart, and then click the Chart Layout tab. Under Labels, click Axis Titles, point to the axis that you want to add titles to, and then click the option that you want. Select the text in the Axis Title box, and then type an axis title.

How do I change the axis values in Excel 2007?

Click the x-axis or y-axis directly in the chart or click the Chart Elements button (in the Current Selection group of the Format tab) and then click Horizontal (Category) Axis (for the x-axis) or Vertical (Value) Axis (for the y-axis) on its drop-down list. Be sure to select the axis values, not the axis title.

How do you add data labels to a scatter plot?

This is what you want to do in a scatter plot:

1. right click on your data point.
2. select “Format Data Labels” (note you may have to add data labels first)
3. put a check mark in “Values from Cells”
4. click on “select range” and select your range of labels you want on the points.

How do you add axis labels in Excel 2008?

Adding an Axis Title

1. Click the chart.
2. Click Toolbox. The Formatting Palette appears.
3. From the Formatting Palette, click Chart Options.
4. From the Titles pull-down menu, select the desired axis.
5. From the Click here to add title text box, type the desired axis title.
6. (Optional) To reposition your axis title,

How do I format axis labels in Excel?

Change the format of numbers on the value axis

1. Right-click the value axis labels you want to format, and then select Format Axis.
2. In the Format Axis pane, select Number.
3. Choose the number format options you want.
4. To keep numbers linked to the worksheet cells, select the Linked to source check box.

How do you round the axis labels in Excel?

Follow these steps:

1. Create your chart as you normally would.
2. Double-click the axis you want to scale. You should see the Format Axis dialog box.
3. Make sure the Number tab is displayed. (See Figure 1.)
4. In the Category list, choose Custom.
5. In the Type box, enter a zero followed by a comma.
6. Click OK.

How do you plot a scatter plot in Excel?

Creating a Scatter Plot Open Excel. Open a blank document. Enter in values for your scatter plot. Click on the Insert tab. Highlight the cells that you want to include in the scatter plot. Click the scatter plot icon. Click the first scatter plot option to make a basic scatter plot.

What is an example of a scatter plot?

Notice how when there is a correlation, the points tend to line up in one direction. A common example of a scatter plot is the relationship between people’s shoe sizes and their IQs. When a large data collection is analyzed, you see that there’s no correlation.

How to add axis labels in Microsoft Excel?

Select the chart that you want to add axis label.

Navigate to Chart Tools Layout tab,and then click Axis Titles.

You can insert the horizontal axis label by clicking Primary Horizontal Axis Title under the Axis Title drop down,…

How do you rotate axis labels in Excel?

Rotate axis labels in Excel 2007/2010. 1. Right click at the axis you want to rotate its labels, select Format Axis from the context menu. See screenshot: 2. In the Format Axis dialog, click Alignment tab and go to the Text Layout section to select the direction you need from the list box of Text direction.