Charts are used in spreadsheets to make it easier to understand large quantities of data by visualizing the relationship between different data series.
The DevExpress ASP.NET MVC Spreadsheet allows you to easily insert a professional-looking chart that displays the details you require. A comprehensive set of 2D and 3D charts is provided to address a broad range of business needs with ease.
To create a chart, select a series of data within a worksheet and click on the required chart type within the user interface Ribbon's Insert tab. The data can be arranged in rows or columns - the ASP.NET MVC Spreadsheet automatically determines the best way to plot the data on the chart. For plotting charts, the Spreadsheet uses the powerful charting functionality of the DevExpress ASP.NET MVC Chart extension.
You can move a chart to any location on a worksheet by dragging it. You can also change the size of the chart for a better fit. By using a chart's context menu you can easily change the main chart characteristics (such as the chart type, underlying data, layout, styles, and etc.).
In this demo, two charts - of the pie and bar types - are created to visualize information presented in the tables.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos