Skip to main content

Pivot Table Integration

  • January 30, 2020
  • 1 reply
  • 42 views

Chris G106

I'm looking to reference specific pivot tables within Google Sheets and therefore when I update base data and the pivot changes that there is an opportunity to dynamically change the table on the diagram. Is this possible?

Comments

Eric R
Forum|alt.badge.img+7
  • Lucid support team
  • February 3, 2020

Hi Chris thanks for posting in the Lucidchart Community!

You can import data from Google Sheets into Lucidchart and then link cells/rows/columns of that data to any shape in your diagram. Working with Google sheets also has the benefit of being able to see live updates from your data. This means that Lucidchart automatically pulls updates made to your spreadsheet and updates the imported data and linked shapes. You can read more about data linking in Lucidchart in this useful Help Center article.

Does this answer your questions? If I have misunderstood could you send me a screenshot of your Lucidchart document or reach out for one on one troubleshooting via this form? Thanks!