Using Matrix Plot Utility
|
Select XLMiner --> Charts -->Matrix Plot. Data Range : Select the data range on which you have to draw the matrix plot. If the cursor is on any of the cells in the dataset you want to use, XLMiner™ automatically selects the whole range. If you want to select any other range, do so by clicking on "-" next to the data range and then enter the required range.
variable names .... : Check this if you want XLMiner™ to consider first row of the data as the variable names.
Variables : The list of variables appears in this window. You can select the ones required and use them for charts by pressing ">".
Chart Title : Enter the chart title here.
Select "OK" to see the output.
See also: |