To specify the data and labels for the chart now, click in the Data Range box, and then select the cells on your worksheet.To move the dialog box out of your way temporarily while you select a range of cells, click Collapse Dialog {bmp 364}.
To simplify the spreadsheet structure:1) Select the merged cells.2) Split merged cells by selecting Unmerge Cells from the ...
To sort a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
To sort a row, click the button to the right of the text box, select a row or cell within the row, and then click the button ...
To specify a header row:1) Select the table and click on the Table Tools | Design tab.2) Check the Header Row table style ...
To specify the data and labels for the chart now, click in the Data Range box, and then select the cells on your worksheet.To ...
To use a chart template, you can choose it when you create a chart (Insert menu, All Chart Types Dialog Box Launcher, Templates ...
To use an Office Data Connection (.odc) file, click Cancel, and then click Existing Connections in the Get External Data ...
To use multiple chart types, choose the Chart Type command or the chart type group command (for example, Line Group) from ...
To use this feature, you must first refresh the PivotTable. On the Analyze tab, in the Data group, click Refresh, and then ...