Google Apps Update Alert - More Chart Options in Sheets

More options for charts, cells, and collaboration in Google Sheets on the web Posted: 15 Jun 2015 11:52 AM PDT When working with spreadsheets, it’s important to take raw figures and turn them into a story. Today’s update to Google Sheets on the web allows people to do just that, offering even more ways to visualize and analyze data. Customized charts, made easier Charts can make even the largest data sets digestible, so we’ve made a few improvements to help people highlight what’s most important. With this launch, people can now: Use data labels to display the exact values of bars and points in charts. Choose different shapes and symbols for data points in both line and scatter charts. Move and resize charts more easily. Data, displayed right Today’s launch also includes new tools for analyzing spreadsheet data. For example, people can: Preview the results of a formula, including any formula errors, instantly as they type. Filter rows and columns by conditions, including “less than,” “greater than,” “text contains,” “date after,” and more. Add calculated fields to pivot tables in order to apply formulas to pivot table data. Use the GETPIVOTDATA function to retrieve data from a pivot table. Collaborate, confidently Collaborating in Sheets can greatly improve the end product, but it’s important to avoid making accidental edits. Currently, people can restrict who can edit an entire worksheet or range of cells using the protected sheets and ranges feature. To reduce the number of unintended changes (e.g. typos) made by people who do have permission to edit, today’s launch includes the ability to warn individuals who attempt to edit certain cells. This will facilitate increased collaboration, as owners won’t need to set complicated permissions in order to allow others to work on the document. Try these updated Google Sheets features on the web today, and start telling better stories with data. Release track: Rapid release and Scheduled release: Calculated fields in pivot tables GETPIVOTDATA functionality Protected cell warnings Live on Rapid release, with Scheduled release to follow on June 29th: Data labels in charts Custom data point shapes in charts Moving and resizing charts Formula previews Filter by condition More information: Create and edit charts in Sheets Functions and formulas in Sheets Work with data in Sheets Filter your data in Sheets Overview of pivot table reports Protect a range or sheet from being edited Note: all launches are applicable to all Google Apps editions unless otherwise noted Launch release calendar Get these product update alerts by email Subscribe to the RSS feed of these updates