Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
580

Chart Commands

Label Chart Points


The StatPlus>Label Series points command can be run when a chart is the
active object in the workbook. You can link the labels to a cell range in
the workbook and copy the cell format. You can also replace the points
in the scatterplot with the labels.

Display Chart Series by Category


The StatPlus>Display series by category command can be run when a chart
is the active object in the workbook. The command divides the chart series
into several different series on the basis of the levels of the category vari-
able. Note that you cannot undo this command. Once the chart series is bro-
ken down, it cannot be joined again.

Select Row from Chart Series


The StatPlus>Select Row command can be run when a chart is the active
object in the workbook. The command selects the row in the worksheet cor-
responding to the point you selected.
Free download pdf