Series F | search
Click here to view Series F news from 60+ newspapers.
Bookmark or Share- AGGREGATE function - Microsoft SupportNote: The function will not ignore hidden rows, nested subtotals or nested aggregates if the array argument includes a calculation, for example: =AGGREGATE(14,3,A1:A100*(A1:A100>0),1)
- Add or remove data labels in a chart - Microsoft SupportTo quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update automatically when changes are made to these values.
- Add a data series to your chart - Microsoft SupportAdd a data series to a chart in Excel. Show a new data series in your chart (graph) by including the series and its name in the chart source data.
- Change the plotting order of categories, values, or data seriesIn the Select Data Source dialog box, in the Legend Entries (Series) box, click the data series that you want to change the order of. Click the Move Up or Move Down arrows to move the data series to the position that you want.
- Edit titles or data labels in a chart - Microsoft SupportYou can reestablish the link by resetting the label text for all labels in a data series, or you can type a reference to the cell that contains the data that you want to link to for each data point at a time.
More
