# How to create a scatter plot in excel 2007

### How do you make a scatter plot on Excel with two sets of data?

### How do you create a trend chart in Excel 2007?

**To add a**

**trendline**and equation manually- Right click on any data point.
- Select Add
**Trendline**. - Select Linear under
**Trend**/Regression Type, and check Display Equation on**chart**and Display R-squared value on**chart**.

### How do you graph an equation in Excel 2007?

To show the

**equation**, click on “Trendline” and select “More Trendline Options…” Then check the “Display**Equation**on chart” box.### Where is the chart elements button in Excel 2007?

Click the

**chart**to select it, choose**Chart**Tools >**Format**on the ribbon and in the top left corner is the**Chart Element**list.### What is the use of AutoSum button in Excel 2007?

If you need to sum a column or row of numbers, let

**Excel**do the math for you. Select a cell next to the numbers you want to sum, click**AutoSum**on the Home tab, press Enter, and you’re done. When you click**AutoSum**,**Excel**automatically enters a formula (that**uses**the SUM**function**) to sum the numbers.### How do I turn on data labels in Excel?

Add

**data labels** Click the chart, and then click the Chart Design tab. Click Add Chart Element and select **Data Labels**, and then select a location for the **data label** option. Note: The options will differ depending on your chart type. If you want to show your **data label** inside a text bubble shape, click **Data** Callout.

### How do you add a legend in Excel 2007?

**Adding**a**Legend**- Click the chart.
- From the Layout command tab, in the Labels group, click
**Legend**. » select**legend**style you prefer. The**legend**style is applied to the chart. - (Optional) To reposition your
**legend**, Click the**legend**. Move the cursor to the border of the text box so it displays a four-headed arrow.

### How do you apply number format to data labels?

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.### How do I align all data labels in an Excel chart?

**Change the position of**

**data labels**- On a
**chart**, do one of the following: To reposition**all data labels**for an entire**data**series, click a**data label**once to select the**data**series. - On the Layout tab, in the
**Labels**group, click**Data Labels**, and then click the option that you want.

### How do I format all data labels in Excel?

Board Regular. Try this: click somewhere in the white space of the plot area. Then right click one of the

**data labels**and select “**Format Data Labels**“.### How do you make a data label in millions?

Follow These Steps

Click the ribbon Home, right-click on the cell, then expand the default to show “Format Cells” dialog. In the Format Cells dialog box, on the Number tab, select Custom, then enter #,, “**Million**” where it says General.

### How do I show 1000000 as 1.0 in Excel?

### How do I show data labels in thousands in Excel?

1. Right click at the axis you want to format its

**labels**as**thousands**/millions, select Format Axis in the context menu. 3. Close dialog, now you can see the axis**labels**are formatted as**thousands**or millions.