Learn to create a scrolling table of data range to use filters without changing the data range.
There can be trouble in visualizing graphs alongside a large dataset as scrolling down would disappear the chart. In order to view the graph and dataset side by side, you can create Scrolling Tables in Google Sheets on the dataset. Scrolling Tables will help you navigate up/down the dataset without actually going down the screen.
Steps to Create Scrolling Tables in Google Sheets
Step 1: Selection of Data Range
- Select the dataset.
- Left-click on cell A1 and drag it down to D18 along with the titles of the variable columns as shown below:
Step 2: Insert Chart for Data Range
- After selecting the cells, click on the Insert tab from the navigation bar and select the Chart option to create a chart for the data range.
Step 3: Select Table Chart
- After selecting Chart, click on Chart Type.
- Scroll down to Other Charts.
- Select Table Chart as shown below.
Step 4: Sort Data
- Once the Table is created, you can sort data without sorting them on the original data range.
- Select on Salary, and you can sort them Ascending or Descending without disturbing the original data range.
- Similarly, you can do this for all other columns
Google Sheets: How to Use Pivot Tables : Learning how to create and use Pivot Tables for analysing data in Google Sheets.