Extract To dialog box

 

Use this dialog box to extract the values corresponding to data points of visible series in a chart into Predictive Systems Lab document worksheets.

 

Extract To

Select one of the following options to specify the cell location where to extract the values corresponding to the chart series.

 

New Workbook

Select this option to extract the chart series values to a new document workbook.

 

New Sheet

Select this option to extract the chart series values to a new worksheet in the currently active document workbook.

 

Range Position

Select this option to extract the chart series values into the currently active workbook worksheet, starting at the cell location specified in the box to the right of this option.

 

Refer to Specifying Output Locations for additional information on this subject.

 

Location

 

Document

Select one of the listed documents to specify the document worksheet to which to extract the chart series values.

 

 

Sheet

Select one of the listed document workbook worksheets to specify the worksheet where you want to extract the chart series values.

 

 

Used Range

Displays the range of cells currently occupied within the specified document workbook worksheet as a reference. Use this range as a guide when specifying a location for a Range Position in order to avoid overwriting valuable information.

 

 

OK

Closes the dialog box and carries out this operation.

 

Cancel

Closes the dialog box without carrying out this operation.