A picture is worth a thousand words–especially at work. The data we present every day is what helps us drive decision-making in the workplace. But understanding how to visualize a story can be difficult if you’re left staring at numbers sitting stagnant in rows or columns within a spreadsheet. 

This is where visualization with charts and reports becomes critical. Let’s say your team needs to understand global sales trends. If you have a waterfall chart that shows regional contribution to total revenue or a scatter plot that shows individual salesperson performance, it’s much easier to spot patterns, draw insights, and make informed recommendations. The same goes for analyzing travel expenses.

In Google Sheets, we have several built-in tools that make it easy to create and share useful charts and reports so that you can quickly visualize data (without having to leave the spreadsheet). Follow these tips to showcase your data in Sheets and influence decisions.

1. Pick the most compelling way to visualize your data.
Perhaps just as important as the data you reference is the way in which you present it. Charts are the basic building blocks for data visualization and can take many forms–from bar charts to line graphs to scatter plots. There are more than 30 chart types to choose from in Sheets, and we’re constantly adding more ways to express your data. Here are a few we recommend:

• To draw attention to a key metric or KPI, try the brand new scorecard chart. For example, you can show the total sales number for your organization’s top-selling product, and even call out percentage increase or decrease over time. 
• To illustrate how values add to or subtract from a starting value, try a waterfall chart. For example, show how your product sales and restocking efforts led to a net decrease in inventory from last quarter to this quarter.
• To represent different data series using lines and bars, try a combo chart. For example, you can show revenue in bars and profit margins in a line across the same chart, giving you a more complete picture of your organization’s financial health.

If you’re unsure how to best present your data, Google’s built-in machine learning can help you choose the right visualization—Sheets intelligently suggests charts for you. Simply highlight data you would like to visualize, click the chart button, and then select one of the suggested charts. According to our internal data, more than 1.5 million charts are inserted into Sheets each week based on intelligent recommendations.

Note: Once you have a chart inserted into Sheets, you may want to control the look and feel. We recently made it possible to click directly on data labels, chart titles, or legends and drag to reposition them. You can also easily delete these elements using the delete or backspace keys, if you want to make other data points stand out. We’re exploring even more ways to customize charts—stay tuned.

2. Be sure to tell a complete story. 
Data really comes to life when you put several charts and tables together into a report or dashboard. Going back to our sales data example, an individual line graph showing revenue over time gives you quick insight into the general sales trend for your organization (hopefully, up and to the right!). But when you surround that line graph with other charts and tables–like a pie chart showing total revenue breakdown by-product, or a stacked bar chart comparing revenue driven by each sales team–you can tell a more complete story. 

If you do build reports featuring multiple charts, there are ways that Sheets can help you organize and format them more quickly. Earlier this year, we made it easier to align, size, and position objects within your spreadsheets so you can quickly put several charts together. We also recently added themes, which let you alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel across the elements in your report. To apply a preset theme, select Format > Theme and choose the right option. Faster formatting can mean faster reporting.

Driving impact over output in a new era of work

As Google’s productivity advisor, I spend a lot of time coaching executives on ways they can make the most of their work day. Over the years, people have come to me with very different ideas about what productivity is, why it matters, and how to achieve it. Often, they think it’s about extracting every last ounce of output from a day—likely because the idea of productivity comes from economics and is most closely associated with factory conveyor belts and efficiency. 

My definition of personal productivity is different. It’s less about getting as much as you can out of each day and more about achieving the things you set out to accomplish and making an impact. 

Productivity is grounded in understanding yourself as a whole person. What makes you happy at work and outside of work? What are your natural rhythms and peak times for creativity, focus, or efficiency? When are you most engaged in meetings? What makes you feel unstoppable when responding to emails? And when do you need to take a break, do some uninterrupted thinking, or deepen social connections with your colleagues? 

When people don’t understand these aspects of productivity, they struggle to make an impact—no matter how well they manage their calendars and inboxes. 

During the global pandemic, we’ve realized the importance of sustaining the wellbeing of ourselves and our families, setting healthy boundaries, and bringing intention to the work day. Among those lucky enough to have the flexibility to work from home, many had to juggle new obligations, from homeschooling to caregiving. And without a solid plan in place, people often found themselves working longer hours and facing burnout.

Now, even as the pandemic enters new and unforeseen phases, many organizations are gearing up for a hybrid work model, Google included. As we make those plans, it’s important that people take a fresh look at personal productivity and plan to maximize wellbeing and impact across all the places they work. 

I developed this new guide with these challenges in mind. It gathers up all my best productivity and wellbeing tips from over the years, including how to:

• Rethink your time and your calendar
• Transform your inbox
• Make meetings more meaningful
• Bring productivity and wellbeing together

As we embrace new ways—and places—of working, all these areas feel more important than ever.

Download The Google Workspace guide to productivity and wellbeing.

By offering customers a choice of 30,000 shoe styles at reasonable prices with a straightforward returns policy, Footway has become one of the largest online shoe retailers in Europe. Founded in 2011 and based in Kista, Sweden, the company has grown to become a market leader and four years ago acquired the Heppo and Brandos brands.

In 2017, Footway expanded from the Nordic market to seven other European countries: Poland, Holland, the UK, France, Germany, Austria, and Switzerland.

To build the business, Footway has had to prove to its customers that buying shoes online is quick and easy. That means, at the backend, processing returns and queries efficiently to provide a seamless consumer experience. However, as the company’s IT infrastructure grew organically, its data storage procedures were not clearly systematized, which made it difficult to implement the efficient, time-saving processes that enable Footway to provide its excellent customer service.

The company needed to move its team onto a system that would resolve this issue, and make compliance to ever-changing data regulations easier. Implementing G Suite was the answer.

“One of our strategic objectives is to automate processes and increase efficiency in our organization,” says Louise Liljedahl, HR Manager and Co-founder at Footway. “We want to work more efficiently every day. One of our main goals with the G Suite project was to get everyone working in the same platform with good structure.”

Systematizing data storage

In order for a relatively small team to run a big retail operation, good organization and process automation are key. Before working with Google Cloud, Footway’s communications and data storage processes were not systematized, making it difficult to work effectively. “Our internal IT had many different places to save files, and, for example, no structure for where to save pictures or graphic elements or where to archive agreements,” explains Louise. “Another trigger for change was the GDPR. To be compliant, we needed to see who has access to what information, and looked for good audit systems to control those permissions”. To do that, Footway implemented G Suite.

With support from implementation partner Avalon Solutions, the migration of the company’s calendar, contacts, and email data using CloudMigrator was swift and seamless. “The transformation process was very lean and quick,” says Louise. “We had a small test group of six people working with G Suite for two weeks to see how to move over to Google Sheets from Excel, for example. Everyone was very enthusiastic.”

To systematize its storage and make day-to-day working easier, Footway moved its document and images to Google Drive. This means Footway can control access both internally and externally. “Google Drive helps us keep everything in the right place. And it is definitely an easier way to share things when it comes to working with external partners, as we know exactly who we’re sharing documents and information with.”

Increasing automation

Following the move to G Suite, Footway automated communications with influencers and bloggers using Gmail and Google Forms. This saves time and means more bloggers can be contacted.

“We send automatic emails through G Suite to different influencers to set up cooperative agreements and partnerships,” says Louise. “Using Gmail and Forms has helped us to go from having contact with 4 bloggers a day, to 200 a day. The person responsible saves two hours a day from his or her workload with this new process.”

Achieving stable growth

Thanks to G Suite, Footway’s data is now organized in a way that is easily accessible and highly secure. “It’s much easier to find company and client information because it’s structured,” says Louise. “That saves a lot of time when searching for something.” The ways people can collaborate have also been transformed, as Footway made the switch to using Google Chromebook, encouraging more flexible working and spontaneous collaboration. “Before, people would take notes on paper and come back to their computer to write everything down. Now they use their Chromebooks instead and have more small, spontaneous meetings.”

Now, Footway plans to extend the use of Chromebooks and to use the functions G Suite offers to further automate the company’s daily processes and grow the business. “People tend to be fearful of change, but this one has been very positive for the whole organization,” says Louise. “We’re excited about how G Suite can help us as a company to grow in a stable way. We can automate processes and use Google products to work more efficiently.”

Editor’s note: This post originally appeared on the Google Workspace blog.

We consistently hear from our customers that the privacy of their data is top of mind, which is why we’ve built state-of-the-art security and privacy-preserving technologies into our products — to keep customer data private and secure. We’ve put Google AI to work on behalf of our customers to automatically stop the majority of online threats before they emerge. Gmail, for example, automatically blocks more than 99.9% of spam, phishing, and malware. These defenses, together with our unique encryption capabilities like client-side encryption (CSE), help our customers such as Groupe Le Monde, PwC, and Verizon, meet their security, privacy, compliance, and digital sovereignty requirements.

Last year, we enabled CSE for Drive, Docs, Slides, Sheets, and Meet, and today we’re excited to share that CSE is generally available for Gmail and Calendar, enabling even more organizations to become arbiters of their own data and the sole party deciding who has access to it. We recognize sovereign controls are important to customers and have accelerated delivery of these encryption capabilities to support our customers in maintaining control over their data and meeting their regulatory compliance needs.

Guarantee complete control of your data for the most challenging regulations

The expansion of CSE capabilities across Google Workspace helps to significantly reduce the burden of compliance for enterprises and public sector organizations. It gives organizations higher confidence that any third party, including Google and foreign governments, cannot access their confidential data. Workspace already encrypts data at rest and in transit by using secure-by-design cryptographic libraries. Client-side encryption takes this encryption capability to the next level by ensuring that customers have sole control over their encryption keys — and thus complete control over all access to their data. Starting today, users can send and receive emails or create meeting events with internal colleagues and external parties, knowing that their sensitive data (including inline images and attachments) has been encrypted before it reaches Google servers.

Users can continue to collaborate across other essential apps in Google Workspace while IT and security teams can ensure that sensitive data stays compliant with regulations. As customers retain control over the encryption keys and the identity management service to access those keys, sensitive data is indecipherable to Google and other external entities.

One key use case for CSE in this context centers on helping organizations subject to regulatory requirements, such as PwC, remain compliant, by meeting the need for the highest levels of encryption for certain types of communication.

“We have been searching for the capability to guarantee that our encrypted communications remain inaccessible to third-parties, including our technology providers, for some time. Google appears to be uniquely positioned with client-side encryption in providing us with complete control over our sensitive data, ensuring that we remain compliant as an organization in the ever changing world of data regulation. These features now being available across Google Workspace represent a pivotal moment for us. We’re enthusiastic about the ability to continue to benefit from the efficiency in working that Workspace provides us with, whilst at the same time maintaining trust with our customers that their confidential data will stay private and compliant,” said Shaun Bookham, UK Operations & Technology Director at PwC.

One of our global telecommunications customers, Verizon, is leveraging CSE to gain complete control over their sensitive data, ensuring that they remain compliant as an organization while supporting customers in highly regulated industries. This opens doors for the company to deliver an exceptional experience for its customers, by extending the level of data protection and privacy to their clients.

“At Verizon, we adhere to governance requirements related to access of our sensitive data while also providing the best experience coupled with deep trust. We have worked alongside Google to develop new encryption solutions and are excited to explore their utilization,” said Russell Leader, Director Collaboration and Mobility at Verizon.

Protecting an organization’s most important assets

The regulatory requirements for separation between an organization’s data and their cloud provider’s environment has resulted in important use cases for client-side encryption — from keeping sensitive R&D data extremely private, even from an organization’s SaaS provider, to scenarios where confidentiality is paramount to the success or failure of a mission-critical operation.

Customers, such as media giant Groupe Le Monde, rely on client-side encryption to protect their most crucial assets. By leveraging client-side encryption across Workspace, Groupe Le Monde can be assured that their communications, appointments, and files will not be subject to leaks, thus helping to keep their journalists safe.

“Client-side encryption gives us the next level of privacy, to ensure integrity within the journalistic process. This allows us to guarantee a higher level of security for our journalists, and to protect our sensitive content,” said Sacha Morard, Chief Technology Officer at Groupe Le Monde.

Another industry-leading Google Workspace enterprise customer uses client-side encryption to protect their most sensitive projects. For these projects, the customer is the sole owner of their encryption keys, thereby protecting their critical intellectual property and maintaining their data sovereignty requirements.

While each customer’s digital transformation journey is different, with all essential Google Workspace apps now being covered by CSE, companies of all sizes in all industries can benefit from these protections.

Starting today, client-side encryption is available globally to customers with Workspace Enterprise Plus, Education Standard, and Education Plus. To learn more about client-side encryption and how to get started today, watch our presentation from Google Cloud Next ’22 and check out the documentation.

In the past two decades, Discovery has moved from a purely cable business based in the U.S. to a global media and entertainment powerhouse. Like many other businesses in the industry, we’ve had to adjust to the unique shifts in people’s behaviors and preferences, almost all of which result from the rise in streaming.

We have always been consumer-obsessed at Discovery, with a corporate culture built on the desire to entertain and inspire people of all ages and backgrounds with exceptional content. As we’ve grown, we have also learned just how important it is to be staff-obsessed, giving our employees the best possible experiences so they can continue to innovate and deliver the world-class content our customers expect.

In 2019, we decided one way to fuel innovation and collaboration among employees was to bring in Google Workspace. Selected for its intuitive, easy-to-use, and constantly evolving tools, Google Workspace enables teams to seamlessly create, connect, and collaborate anywhere, anytime.

Given the scope of our ambitions, and recognizing the challenges of migrating 16,500 global employees to a new collaboration solution, we worked with Google Cloud premier partner SADA to get the job done.

Change management amid a massive migration

We began the move to Google Workspace by migrating our document storage system from a legacy cloud provider to Google Drive. This included 86 million items amounting to about two petabytes of data migrated with minimal disruptions. A few months later we completed our move to Google Workspace by migrating 1.2 million calendar invites and 20,800 mail accounts, including thousands of collaborative inboxes and delegated accounts.

In addition to the technical support and Google Workspace expertise that SADA provided, they also partnered with our project team on the change management strategy. Despite challenges presented by the COVID-19 pandemic, our training team and SADA were able to offer outstanding educational opportunities to assist our workforce in the transition and to get the most out of Google Workspace.  This included collaborating on over 240 global webinars in seven languages.   

Discovering the power of transformative tools

Discovery has many types of end users, from finance professionals and marketing teams to producers and content developers. The fact that Google Workspace has been well-received across the company is a testament to the power of the solution.

Many of our teams have taken advantage of collaborative Gmail accounts and shared drives, providing them with a centralized location to seamlessly communicate and work together on team-focused projects. Our internal communications team is especially happy with the real-time collaborative editing experience within Docs as they work on company-wide emails, announcements, and other projects. 

These collaboration tools have allowed us to stay agile amid global lockdowns and will continue to do so as we adapt to a more flexible working environment.

The value of partnership

While we were comfortable with our legacy collaboration suite, one of the biggest benefits of switching to Google Workspace has been Google Cloud’s and SADA’s partnership. They provide us with regular updates on product roadmaps, upcoming features, and more.

This is just the beginning as we plan to grow, deliver new content, and lead the media and entertainment industry with the help of these two great partners and their solutions.

To learn more about Discovery’s journey with Google Workspace, read the full case study.