Click or drag to resize

Charts

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:

Supported chart types

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.

Chart Components

Every chart is composed of components.

All charts can have title and legend

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:

Navigate to ExcelChart.getTitle() methodNavigate to ChartSeries.getIsLegendEntryVisible() methodNavigate to ExcelChart.getLegend() methodNavigate to ChartAxis.getTitle() methodNavigate to ChartAxis.getTitle() methodNavigate to ExcelChart.getCategoryLabels() methodNavigate to ChartAxis.getMajorGridlines() methodNavigate to ChartAxis.getMajorGridlines() methodNavigate to ChartAxis.getMinorGridlines() methodNavigate to ChartAxis.getMinorGridlines() methodNavigate to ValueAxis.getMaximum() methodNavigate to ValueAxis.getMinimum() methodNavigate to ChartAxis.getNumberFormat() methodNavigate to ValueAxis.getMajorUnit() methodNavigate to ValueAxis.getMinorUnit() methodNavigate to ChartAxis.getMinorTickMarkType() methodNavigate to ChartAxis.getMinorTickMarkType() methodNavigate to ChartAxis.getMajorTickMarkType() methodNavigate to ChartAxis.getMajorTickMarkType() methodChart Components

Preservation

Following charts types are currently not supported by GemBox.Spreadsheet API:

  • 3D charts (Column, Bar, Line, Area and Pie).

  • X Y (Scatter) charts.

  • Stock charts.

  • Surface charts.

  • Doughnut charts.

  • Bubble charts.

  • Radar charts.

Note Note

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.