When we select data on the worksheet to create a chart, there may beinstances when we need to select non-contiguous data (data that is notnext to other data). If you do not want to make a graph out of all yourinformation, you would need to select only the information you require.We call this selecting non-contiguous information:
- Highlight (select) the first range of data to include in thechart.
- Hold down the Ctrl key on the keyboard while dragging(selecting) the next range with your mouse.
- Release the Ctrl key once you have selected the data.
- Continue to the Insert tab tocreate the chart as usual.
- Once you have finished creating the chart, click off the chart ontothe worksheet, and then select the chart again by clicking on it, asillustrated in the following screenshot:
- Notice that the worksheet data does not select when selecting thechart as the first chart does—this is because the chart has anon-contiguous selection. So, to view the worksheet data, click on adata series to display the connected worksheet data, as shown in thefollowing screenshot:
Let’s continue to learn more about editing charts in the nexttopic.