Plotting non-contiguous data in Microsoft Excel 2019

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:

  1. Highlight (select) the first range of data to include in thechart.
  2. Hold down the Ctrl key on the keyboard while dragging(selecting) the next range with your mouse.
  3. Release the Ctrl key once you have selected the data.
  4. Continue to the Insert tab tocreate the chart as usual.
  1. 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:

ms office 480

  1. 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:
ms office 195

Let’s continue to learn more about editing charts in the nexttopic.

Leave a Comment