This sample visualizes the data using chart feature by comparing the GDP of different countries with various years.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| Gross Domestic Product (in trillions) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Country | Year 2017 | Year 2018 | Year 2019 | Year 2020 | ||||||||||||||||||||||||||||||||||||||||||||||
| USA | $18.00 | $20.40 | $21.42 | $19.48 | ||||||||||||||||||||||||||||||||||||||||||||||
| China | $11.00 | $14.00 | $14.32 | $12.23 | ||||||||||||||||||||||||||||||||||||||||||||||
| Japan | $4.40 | $5.10 | $5.08 | $4.87 | ||||||||||||||||||||||||||||||||||||||||||||||
| Germany | $3.30 | $4.20 | $3.84 | $3.69 | ||||||||||||||||||||||||||||||||||||||||||||||
| India | $2.00 | $2.85 | $2.87 | $2.65 | ||||||||||||||||||||||||||||||||||||||||||||||
| UK | $2.90 | $2.94 | $2.82 | $2.63 | ||||||||||||||||||||||||||||||||||||||||||||||
| France | $2.40 | $2.93 | $2.71 | $2.58 | ||||||||||||||||||||||||||||||||||||||||||||||
In this demo, the chart has been inserted in the specific cell position by using the chart
property in the cell object. You can also insert a chart by using the insertChart
method.
To enable or disable this feature use the allowChart
property in Spreadsheet.
This sample is configured with import and export options. Use Ctrl + O to open an excel file and Ctrl + S to save an excel file with chart.
More information about the chart can be found in this documentation section.