Data Visualization with Google Sheets

Visual Paradigm support visualize your data into various charts. This feature gives you valuable insights to your data. The data can be visualized by entering with the build-in spreadsheet tool, upload of Excel file, or directly link from Google Sheets. In this article we will show you how to feed in data to your chart by link to Google Sheets.

Configure Google Sheet

1. Open you Google Sheet.
2. Go to Files > Publish to the web…
   

   Select File > Publish to the web

3. Select the worksheet.
   

   Select worksheet

4. Press Publish button to publish it.
   

   Publish worksheet

5. Close the Publish to the web dialog.
6. Press the Share button at the top right of the spreadsheet.
   

   Share worksheet

7. Press the Get shareable link button to obtain the share link of your spreadsheet.
   

   Generat shareable link to your worksheet

8. Copy the share link to clipboard.
   

   Copy the link to clipboard

Configure Your Chart

1. Create any chart using the Data Visualization tool.
   

   Create chart

2. Specify the name of the chart.
   

   Specify the name of your chart

3. Press the Options button in chart editor to bring up the option settings.
   

   Open option settings

4. Paste the share link of your spreadsheet into the Link field under Link to Google Sheet, then press the Link button to establish the linkage.
   

   Link to Google Sheet

5. The preview of the chart will be updated according to the data in your spreadsheet.
   

   Chart preview updated according to data in Google Sheet

6. You can also turn on the Auto refresh of the chart to have it automatically pull the data from your Google Sheet in specified interval.
   

   Auto refresh data from Google Sheet

7. Press on the chart editor to close the configuration and have your chart updated.
   

   Google Sheet data visualized on chart