How to Make a Chart with Data in Multiple Tabs
Keywords: Google, Sheets,
Aliases: Spreadsheet, Excel
1. Here I've created an example sheet with some data.
2. Now either create a tab for your graph or click into the tab you would like to create the graph in, I made a separate tab for the sake of ease. Now on the top bar click Insert > Chart.
3. Move the inserted graph to the location you'd like it. Then with the graph selected, go to the right panel and select the type of graph you want to use.
4. Now on the right panel in the data range field, click the little boxes icon.
5. This window will pop up, if you're lucky the range you want will be under "suggested ranges". Otherwise, click into the text field and then to the tab that you want to pull data from. The mini window should still stay up.
6. Now select the range that you want the chart to point at and it should populate in the range text field. If you need to add another range, click "Add another range" and repeat steps 5 and 6 until you have all your data selected. Alternatively you can type in the ranges manually using the following syntax (it has to be exactly right):
'NameOfTab'!Cell:Range
As an example if you want cells 1 through 20 on column A on Tab 2, you would type out the following:
'Tab 2'!A1:A20
6. Now you should have all your data selected properly! If you want further information on how to configure charts, please look at this solutions article or call x3711.
