Selecting Noncontiguous Data to Chart in Excel 2007:-

It is helpful, but not necessary, for your data to be in a contiguous range. In the Figure (given below), for example, you might want to create a pie chart that includes the category labels in column B and the totals in column F. To select data for creating a chart, you follow these steps:

1. Click in cell B1 and drag to cell B4 in order to select the range of category labels.

2. While holding down the Ctrl key, click in cell F1 and drag down to cell F4 in order to add F1:F4 to the selection.

3. If you have additional series to plot, repeat step 2 for each additional series.



(Selecting noncontiguous data requires a bit of dexterity, as you attempt to drag while holding down the Ctrl key.)