Example of Chart in ASP.NET MVC Spreadsheet Control
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 |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| Gross Domestic Product (in trillions) | |||||||||||||||||||||||||||||||||||||||||||||
| Country | Year2017 | Year2018 | Year2019 | Year2020 | |||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||
Gross Domestic Product (in trillions)
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 insertChartopens in a new tab method.
To enable or disable this feature use the allowChartopens in a new tab 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 Spreadsheet component can be found in this documentation opens in a new tab section.