LineChart.png

Google Chart Widgets (Area, Bar, Candlestick, Column, Line, and Pie) are designed to turn Google Sheet data into beautiful looking charts.


To learn how to add a Widget to your Composition, click here.

Remember, any underlined widget properties can be connected to a Control Node or a Data Node.

Properties

As seen above, select the dedicated "Chart" tab in the Property Panel to update the widget's following property types:

Google Sheets Connection

Google_Chart_Google_Sheets_Connection.jpg

Spreadsheet ID - Id number of your Google Sheet spreadsheet. This value can be found in the url between "/d/" and "/edit".

Value Range - The range of your desired columns and rows of data in A1 Notation. For example, "SheetName!A1:E12"

API Key - Google account API Key. This can be created following this tutorial.

Fetch Sheet Data - Manual button to pull in updated sheet data.

Request Frequency

Check the "Enable" box to activate this property feature set.

Screen_Shot_2020-09-22_at_1.17.59_PM.png

Request frequency - Every number of seconds Singular will request data from your Google Sheet.

Basic Layout Parameter

Screen_Shot_2020-09-22_at_1.18.03_PM.png

Show grid and labels - Activate grid and labels on chart

Size of grid labels - Change the grid label size (in pixels)

Expert Layout Parameter

Check the "Enable" box to activate this property feature set and override the Basic Layout Parameter settings.

Screen_Shot_2020-09-22_at_1.18.12_PM.png

Expert Layout Parameter - Various customizable layout parameters in JSON format

There are various configuration options for each individual chart style:

Sample Chart Data

Each Chart Widget requires certain styles of data. For example, a Candlestick Chart requires more complex data than a Line Chart.

Check out our sample data for each Google Chart Widget.

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.