Once you select a spreadsheet, the editor picks existing charts from the spreadsheet to embed into a Site.
="http:> ="http:>
You can also create a chart by specifying the sheet and range and customize the chart by changing various properties such as color, axes, labels and more. Choose which chart type best expresses your data or let the chart editor recommend one for you.
You can decide to choose between two modes Live and Snapshot to show the data.
Live provides you with dynamic charts. Whenever the chart is loaded in the Site, the chart will display the most recent data in the spreadsheet. This is very useful in cases when the spreadsheet data is updated manually or using a script.
Snapshot means just that. It’s a snapshot at a point in time, so the chart will store and display the exact same data, regardless of whether you make changes to the underlying data sheet.
="http:>
="http:>
Changes made to charts in Sites are independent to the specific chart, so the same spreadsheet data can be applied across multiple charts.="http:>
="http:>
To learn more about how to express your data more visually with Sites, visit the help center. Be sure to let us know what you think in the comments.
This versatile function is often used by accountants, finance professionals, and business consultants. It can also be extremely convenient for any user -- let’s show you why.
Say that you’re helping to plan your family’s annual Labor Day beach weekend. You want to decide how many hot dogs and veggie dogs to buy. To figure this out, you create a Google spreadsheet that includes all your family members, their meat preferences, and the number of hot dogs everyone ate at the past several family gatherings:
To quickly count how many veggie dogs you need to buy based off the number of veggie dogs eaten last month, add a filter to the columns , sort to “Yes” only in Column C, and type in this Subtotal function underneath the table:
=SUBTOTAL(109, F2:F14)
Cells F2 through F14 show the number of hot dogs each family member ate last month. “109” is the code that references the Sum function (“9” would also work). Typing in a regular Sum function in this case (=SUM(F2:F14)) would have added all dogs, veggie or not, whereas Subtotal ignores hodogs which have been filtered.
Another neat feature of the Subtotal function is that the function code (such as “109” above) can easily be changed to refer to different operations like Average, Minimum, and Maximum. As a result, Subtotal can be used to condense a number of calculations into a small space.
Let’s say you want to see not only the total number of hot dogs eaten each summer month, but also the average number eaten. Rather than creating two different functions (Sum and Average) for each month, you can use Subtotal.
In an open cell -- let’s use B15 -- you would create a drop-down list with the codes for the Sum and Average function (109 and 101 respectively).
And under the column for each month, you would write a Subtotal function, but reference cell B15 instead of typing in a code.
For June, therefore, your function would read: =SUBTOTAL(B15, D2:D14)
Every time you change which code appears in cell B15 through the drop-down, the values under each month will change, showing either the total or the average number of hot dogs eaten by your family with just one click.
We hope the Subtotal function makes your data analysis a lot easier -- and maybe even more fun.
While using the new interface, you may want to see more of the items in your documents list on the screen at one time. To do this, click on the gear icon in the upper right and go to Documents settings. Under Row height, you’ll be able to select the option to use a denser view.
As part of this new look, we’ve also added keyboard shortcuts to help you easily navigate your documents list without a mouse. For example, when selecting a document, use the ⇓ (down arrow) to move down the list and the ⇑(up arrow) to move back up. Once you find the item you're looking for, type a to open the Actions menu. Then, use the ⇑ and ⇓ arrow keys to navigate the Actions menu, and hit to select an action.
The Create new shortcuts are also convenient for creating new docs while you’re working. Simply hit Shift + T to create a new text document, Shift + S to create a spreadsheet, or Shift + C to create a new collection.
Can't remember all those shortcuts? Just remember the question mark. Type ? when you’re not in the search bar, and a window will appear showing all available shortcuts.
These shortcuts will only be available if you’re using the new interface. Keep an eye out for more changes to the new interface as it evolves, and make sure to tell us what you think about the new design in this brief feedback form so we can continue to improve your experience.
