Google Sheets is by far the most popular spreadsheet app online, with good reason: free with any Google Apps account, it’s both powerful and easy to use. But even the best organized data collection can turn into a confusing eyesore. That’s why we’re pleased to share the Lucidchart add-on for Google Sheets.
Matching data with diagrams
Adding an explanatory diagram to a data set gives context, so viewers can grasp the situation right away and better know what to do as a result. A sitemap is a perfect companion to a data set showing the results of pages undergoing A/B tests. A flowchart explaining changes to a business model over the past year nicely complements a year-end financial report. From mockups to Venn diagrams, the possibilities for combining info with images are endless. Lucidchart diagrams fill a different role than the Google Sheet built-in chart generator. Lucidchart diagrams supplement data sets with context and insight, and the Google Sheet chart generator converts a data set into an easy-to-digest visual. Both approaches add a necessary level of clarity and depth to your communication.
There are two ways to install the Lucidchart add-on for Google Sheets:
- While editing a Sheet, click “Add-ons,” then “Get Add-ons” and search for “Lucidchart.” Click “Free” to install.
- From the Chrome Web Store listing for Lucidchart, click “Free.”
In both cases, grant permission to link Lucidchart with Google Sheets as prompted.
Using the add-on
Follow these steps to easily insert a diagram in Google Sheets:
- On the add-ons menu, click “Lucidchart Diagrams for Sheets,” followed by “Insert diagram.”
- Sign into Lucidchart in the sidebar, or sign up for a free account.
- Select the document you’d like to add and click “Insert.”
- Click and drag to reposition the image after it appears.
There are also options for setting a fixed image size or creating a new document. If you create a new document, be sure to close and reopen the sidebar to refresh the document list. Adding diagrams to any Google Sheet gives your project the effectiveness and power of visualization.