Learn how to customize your visual data

Reading time: about 3 min

Topics:

Spreadsheets are fine for capturing data, but when it comes to understanding trends, comprehending the numbers, and making informed decisions, spreadsheets just don’t cut it. Lucidchart puts data to work by transforming it into a visual landscape.

This article is a sampling of our free “Customizing Your Visual Data” course. In the course, you can expect a deep dive into:

Importing data into a Lucidchart document
Customizing a template shape that’s prepared to display the data you’ve selected
Linking your spreadsheet data even faster with mass importing
Creating a template document

We’ll touch on those topics here, but for the full experience, register for the course. You’ll get easy-to-follow videos, practice activities, and helpful tips.

Prepare to link by importing data

How do you get your data into a Lucidchart document? Choose the method that works best for you.

Click on the data icon on the left side of the screen, then click Link data.
You’ll be given several options for importing your data. You can import from an Excel or CSV file or even from Google Sheets. Linking from Google Sheets allows you to see live updates to your data. Select your type of spreadsheet, then Choose file.

Note: if you have multiple data sets—such as a CSV and a Google Sheet—you can add them all to the same document.

Increase efficiency with template shapes and libraries

Once your data is imported, you can create shapes that will tell the visual story of your data. With Lucidchart data linking, you no longer have to edit the data in shapes manually.

Choose the specific data fields you’d like to display on each shape. Then, copy, paste, and replace with new data on that shape or save it as a template shape within a library. Now, you can drag and drop data directly into your Lucidchart diagram. Add lines and other symbols to connect shapes and draw conclusions from the data presented.

Streamline with mass importing and template documents

Once you’ve got data, diagrams, and your library set up, you can utilize mass importing to select multiple lines of data and link them to shapes simultaneously. Simply select the lines you want to work with and drag and drop to link to multiple shapes simultaneously. Then rearrange as needed.

If you’d like, you can save your diagram as a template by going to File and then choosing Convert to template. That way, if you want to change something down the line, you don’t need to start from scratch. Templatizing also allows you to create standardization for consistent documentation across your business.

Data linking in your Lucidchart diagrams ensures that you’re making the most of your data. Create captivating stories out of confusing spreadsheets and make decisions based on facts, not guesswork.

It’s time to get your hands on that data and make it a masterpiece. Register for the course and start watching videos—you’ll become a data visualization diagramming champ in no time.

Go now

About Lucid

Lucid Software is the leader in visual collaboration and work acceleration, helping teams see and build the future by turning ideas into reality. Its products include the Lucid Visual Collaboration Suite (Lucidchart and Lucidspark) and airfocus. The Lucid Visual Collaboration Suite, combined with powerful accelerators for cloud and process transformation, empowers organizations to streamline work, foster alignment, and drive business transformation at scale. airfocus, an AI-powered product management and roadmapping platform, extends these capabilities by helping teams prioritize work, define product strategy, and align execution with business goals. The most used work acceleration platform by the Fortune 500, Lucid's solutions are trusted by more than 100 million users across enterprises worldwide, including Google, GE, and NBC Universal. Lucid partners with leaders such as Google, Atlassian, and Microsoft, and has received numerous awards for its products, growth, and workplace culture.

Level up your diagramming with conditional formatting [+course]
Gain insight into your data in Lucidchart like never before with conditional formatting. Includes a free course!
Best practices for effective data visualization
Whether pitching for funding for a new project or describing year-over-year performance to shareholders, make your point more clearly with the right data viz. Take a look at these data visualization best practices.
Conveying your vision with Lucidchart diagrams [+course]
Using Lucidchart diagrams, you can not only present your vision but convey it in a way that drives impact and action. Register for the course!
Customizing your Lucidchart diagrams (+ free course!)
Access the full course in Lucid Training Labs to view video training and other tools for customizing your diagrams.