# Data Table

DsExcel Java is a MESCIUS Documents product that offers a comprehensive library to create, manipulate, convert, and share Microsoft Excel-compatible spreadsheets.

## Content





Chart data table refers to a grid displaying source data of the chart and is drawn beneath the chart. The data table along with the chart is an organized form for reading exact values especially when data labels are difficult to read or are not set.

![](https://cdn.mescius.io/document-site-files/images/dd59ea42-cd61-4fa6-a018-6231c2a9c598/images/chart-data-table.png)

DsExcel Java allows you to insert data table beneath chart by using **setHasDataTable** method of the **IChart** interface. You can display data tables for the Column, Line, Bar, and Area chart by setting the setHasDataTable method to **true**. However, for any other chart types, the method returns false.

Once a data table is added, you can configure the same by using various methods of the **IDataTable** interface. The interface provides **setHasBorderHorizontal**, **setHasBorderVertical** and **setHasBorderOutline** methods to display the cell borders and table outline respectively. You can configure the fill and line style of data table by using the **getFormat** method.

To remove the data table of a chart, you can call **delete** method of the IDataTable interface.

Refer to the following example code to add and configure a chart data table in DsExcel:

```Java
//Create chart.
IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 0, 350, 250);
shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C3"));
shape.getChart().getChartTitle().setText("Estimated vs Actual");

//Display the data table.
shape.getChart().setHasDataTable(true);

//Config the data table.
IDataTable datatable = shape.getChart().getDataTable();
datatable.getFormat().getLine().getColor().setObjectThemeColor(ThemeColor.Accent6);
datatable.getFont().getColor().setObjectThemeColor(ThemeColor.Accent2);
datatable.getFont().setSize(9);
```

**Limitation**

Chart data table cannot be exported to JSON, PDF, HTML or image format.