Report editors can reference data between manual tables or charts as needed to keep information up to date across the document using the dynamic cross-table formula “ImportRange.”
Reference Data Across Manual Tables and Charts Walkthrough
Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon.
Step-by-Step Instructions
- Click Edit Table or Edit Chart on a manual table or chart to begin.
- We recommend using this on another sheet within the table or chart. Select the plus (+) next to “Display” to create a new sheet.
- Within a cell in the sheet, type =import to be prompted to select the IMPORTRANGE formula helper.
- Select the table you wish to reference within the Select Source Table field.
- Select any and all cells within the table you wish to reference. You can select one cell up to the entire table. Select Insert Formula when ready.
- Click over to the Display tab to reference the table.
- Type = (equals sign) in a cell and then navigate to the Sheet with the table.
- Select the cell(s) to reference.
- Click Display and select Enter to finalize the formula.
Frequently Asked Questions (FAQs)
Q: Can I use the importrange formula to reference a table within a chart?
A: Yes! This is a great way to create a data visualization of a manual table.
Have more questions or need assistance?
Submit a Request