Microsoft KB Archive/61426

{| = Excel: Creating a Chart from Noncontiguous Data =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q61426

SUMMARY
A chart can be created in Microsoft Excel from noncontiguous data. To create a chart from noncontiguous data, do the following:


 * 1) Select the first block of cells that contains data to be charted.
 * 2) Hold down the COMMAND key and select the next block of cells that contains data to be charted.
 * 3) Repeat step 2 until all noncontiguous data has been selected.
 * 4) From the File menu, choose New, and select Chart.

To create a chart in Microsoft Excel from noncontiguous data by using the Copy and Paste or Paste Special commands, do the following:  Select the first block of cells that contains data to be charted. From the Edit menu, choose Copy. Select a cell in a remote area of the worksheet; for example, $AA$1. From the Edit menu, choose Paste Link. This creates a link to the original data. Select the next block of data to be charted. From the Edit menu, choose Copy. Select the cell to the right of the Paste Link information. For example, if you chose $AA$1 in step 3, select $AB$1. From the Edit menu, choose Paste Link. This creates a link to the original data.</li>  Repeat steps 5-8 for all remaining blocks of data. Note: It is important to Paste Link the information into a single, continuous block of data. </li> Create a chart with this continuous block of data.</li></ol>

Since the values in the continuous block of data are linked to the original values, any changes made to the original values will be reflected on the chart.

MORE INFORMATION
Excel stores information in the Clipboard in the format &quot;nR x nC,&quot; where &quot;nR&quot; is the number of rows and &quot;nC&quot; is the number of columns. This information must be organized in a continuous block of data.

To control the way information is charted in Excel, you must use the Copy command in conjunction with the Paste Special command. Because a noncontiguous block of data cannot be copied or cut, the data must be relocated into a continuous block.

It is possible to create a scatter (X-Y) chart using discontinuous data in Excel version 2.2. Query on &quot;Excel Scatter Discontinuous&quot; for more information.
 * }