Charts

A chart represents the data in graphical format. Hence, it is extensively used in data analytics, especially when users want to make sense out of large chunks of information lying in the spreadsheets.

SpreadJS provides support for the chart functionality just like in Excel. You can insert different types of two-dimensional charts in spreadsheets and customize their elements in order to allow users to visualize data in an efficient way and quickly summarise information for advanced information analysis.

The chart functionality in SpreadJS is provided as a plugin feature which makes it extremely easy for users to create charts and gives them the flexibility to customize them.

With extensive support for eleven chart groups, thirty-three chart types, and combo chart ability, you can insert any kind of two-dimensional charts in your spreadsheets, set custom chart layout, customize chart elements as per your preferences and combine multiple chart types in order to evaluate financial information, perform stock analysis, and look over sales revenues in just a few clicks.

The most basic example of a chart is shown below:

For more information on configuring chart elements for custom chart layout, working with different chart types, using animation in charts, and customizing chart color with transparency, refer to the following topics:

• Chart Elements

• Chart Types

• Add Trendlines To Charts

• Add Error Bars In Charts

• Animation in Charts

• Add Hover Animation and Style

• Chart Color with Transparency

• Display Empty Cells in Chart

• Hidden Rows or Columns in Chart

• Preserve Unsupported Charts

• Pattern Fill in Charts

Note: In order to work with charts in a spreadsheet, users need to reference the file: gc.spread.sheets.charts.*.*.*.min.js.