A 3d Bar with Data from Google Sheets

rgraph supports retrieving data from Google sheets via setting parameter data="sheets" and "sheets_parm". With "sheets_parm you must provide a key of the spreadsheet created at google sheets and published to the web. As a second parameter you may specify the number of rows to retrieve (if not specified all rows will be retrieved). If the third parameter is set to true, then first row's data will be used as keys for the columns. If parameter "sheets_cols" is set, only selected colums defined there are processed for chart's data.

Parameter for creation of chart

{rgraph title="Data from Google Sheets" width="550" height="300" grouping="stacked" 
key="Fred,Lucy,Lilly" tooltip="#key#: #val# <br>Total #total# in #label#" keyPositionX="200" marginBottom="80"
data="sheets" sheets_parm="1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E,12" sheets_cols="Fred,Lucy,Lilly"
variant="3d" xaxisLabelsAngle="20" tooltipsEvent="onmousemove" keyPositionY="60" textAngle="20"}sheets{/rgraph}   

 

[No canvas support]>

 

Important: If you want to test this sample via copy/paste, ensure that you paste with option "paste as plain text" otherwise imbedded html-codes may invalidate your input.
go back...

Visitors

Today: 2
Yesterday: 48
This Week: 84
Last Week: 620
This Month: 1,780
Last Month: 1,635
Total: 220,576
0220576
Germany 29.7% Germany
USA 24.6% USA
France 3.1% France
Italy 2.7% Italy
Indonesia 2.2% Indonesia
Poland 2.0% Poland
Spain 1.8% Spain
India 1.8% India
Netherlands 1.7% Netherlands

Total:

207

Countries

Weather

Weather in Ashburn

22nd March, 2023 - 1:44
Broken Clouds
11°C 8°C min 13°C max
12:12 0:22
Humidity: 33 %
Wind: 4.1 km/h SouthEast
Pressure: 1,028 hPa
Visibility: 10,000m
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.