In the formula bar hit equals and select the cell reference that contains the data for your chart label. Excel has a variety of formulas and functions. Select the chart area of a chart click in the Formula Bar or not Excel will assume youre typing a SERIES formula and start typing.
Select the chart area of a chart click in the Formula Bar or not Excel will assume youre typing a SERIES formula and start typing.
To move the legend to the right side of the chart execute the following steps. Doubleclick on the trendline to open the settings pane. Select the new added scatter chart and then click the Trendline More Trendline Options on the Layout tab. In the Category drop-down list select Number.