how to make a pie chart in excel with non adjacent ranges

Therefore with Multiple Selection Range, a collection of non-adjacent cells are selected. To define a range, it's not necessary to select only the adjacent cells. For instance, in the below example, the mixed Range is A2: E10. Mixed Range refers to the collection of cells formed by combining adjacent rows and columns. However, if you select the entire row, the vertical range would be 2:2. For example, in the below image, the horizontal range is A2:E2. Horizontal Range refers to the selection of cells within a row. However, if you select the entire column, the vertical range would be A: A. For example, in the below image, the vertical range is A1:A5. Vertical range refers to the selection of the cells within a column. We have selected B2:B6, C3:C6, D4 range of cells.

Hold the 'CTRL' key on your select and the various non-adjacent cells. Similarly, you can select any range of cells in your Excel worksheet. As you can see, we have dragged our pointer to the D5 cell. Drag your cursor to the last cell of your range.In our case, we have selected the B2 cell. Select the cell from where you want to start selecting your range.You select the range and change the background colour of the cells.įollowing are the steps to select a range in Excel: A. For example, let's suppose you can highlight the headers in the cell range A2:E2. While working with excel, you may want to select a multi cell range so you can easily make a command for all the cells at once. In this tutorial, we will briefly cover all the topics about ranges.

You can perform many operations with ranges in your Excel worksheet, unlike copying the dataset, moving data from one position to another, formatting cells, and even you can name your range. In excel, each range has its defined set of coordinates or positions, unlike A4:A7, B5: F9C, etc. It can also be used to refer to the adjacent cells or non-adjacent cells in the dataset. Whenever we see the word range in excel, we refer to it as a cell or a collection of cells in an excel spreadsheet.

How to make a pie chart in excel with non adjacent ranges