Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
The following sections contain information about charts in GemBox.Spreadsheet component:
GemBox.Spreadsheet for Java supports following chart types:
Additionally, GemBox.Spreadsheet for Java supports following chart groupings:
Manipulating charts with GemBox.Spreadsheet component is easy and straightforward. See chart example how to create chart and select data for it using GemBox.Spreadsheet for Java.
Every chart is composed of components.
Some charts, for example, have axes, and others, like PieChart don't. Most charts have horizontal axis of type CategoryAxis (or DateAxis in case when categories are dates) and vertical axis of type ValueAxis, but some, like BarChart, have the opposite.
An ChartAxis can have a title, labels, tick marks, gridlines, etc.
Following diagram outlines chart components and links each chart component to its corresponding member in GemBox.Spreadsheet API so you can easily locate each member by following the link:
Following charts types are currently not supported by GemBox.Spreadsheet API:
3D charts (Column, Bar, Line, Area and Pie).
X Y (Scatter) charts.
Support for these chart types will be added in future versions of GemBox.Spreadsheet based on customer feedback.
Although not supported by GemBox.Spreadsheet API, these chart types are still preserved, so you don't lose any chart when loading and saving to XLSX file format. There are even techniques to update data for preserved chart when workbook is opened in MS Excel as shown in chart preservation example.