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" ymax="90"
key="Fred,Lucy,Lilly" tooltip="#key#: #val# <br>Total #total#"
data="sheets" sheets_parm="1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E,12" sheets_cols="Fred,Lucy,Lilly"
variant="3d" textAngle="20" variantThreedAngle="0.06" tooltipsEvent="onmousemove"
keyPosition="gutter" gutterBottom="70" keyPositionY="60" }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: 17
Yesterday: 7
This Week: 17
Last Week: 115
This Month: 417
Last Month: 593
0143983
United States 35.8% USA
Germany 13.1% Germany
Russia 4.5% Russia
France 3.2% France
Italy 2.6% Italy
Indonesia 2.6% Indonesia
India 2.4% India
Poland 2.3% Poland

Total:

203

countries
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok