Example of Chart in ASP.NET MVC Spreadsheet Control

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.

The ASP.NET MVC Spreadsheet component includes a wide range of built-in chart types that help users analyze, compare, and present spreadsheet data visually—similar to Microsoft Excel charting.

• Column Chart - Ideal for comparing values across categories, such as GDP, revenue, or sales performance between countries or years.
• Bar Chart - Best suited for ranking and comparison scenarios, especially when working with longer category labels.
• Line Chart - Commonly used to visualize trends, patterns, and changes in data over a specific time period.
• Area Chart - Highlights overall growth trends while emphasizing cumulative and total values.
• Pie Chart - Clearly represents percentage distribution and part-to-whole relationships within a dataset.
• Doughnut Chart - A modern alternative to pie charts, useful for proportional analysis with improved visual focus.
• Scatter Chart - Helps identify relationships, data distribution, and correlations between two numerical variables.
• Bubble Chart - Visualizes three dimensions of data using position and bubble size for deeper comparative analysis.
• Radar Chart - Compares multiple metrics across categories, such as KPI performance or feature analysis.

These charts can be created directly from spreadsheet ranges, enabling users to transform raw Excel data into interactive visual insights without leaving the Spreadsheet environment.

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.