Search in sources :

Example 1 with ScatterChartSeries

use of org.apache.poi.ss.usermodel.charts.ScatterChartSeries in project poi by apache.

the class XSSFScatterChartData method addSerie.

public ScatterChartSeries addSerie(ChartDataSource<?> xs, ChartDataSource<? extends Number> ys) {
    if (!ys.isNumeric()) {
        throw new IllegalArgumentException("Y axis data source must be numeric.");
    }
    int numOfSeries = series.size();
    Series newSerie = new Series(numOfSeries, numOfSeries, xs, ys);
    series.add(newSerie);
    return newSerie;
}
Also used : ScatterChartSeries(org.apache.poi.ss.usermodel.charts.ScatterChartSeries)

Example 2 with ScatterChartSeries

use of org.apache.poi.ss.usermodel.charts.ScatterChartSeries in project poi by apache.

the class TestXSSFScatterChartData method testOneSeriePlot.

@Test
public void testOneSeriePlot() throws IOException {
    Workbook wb = new XSSFWorkbook();
    Sheet sheet = new SheetBuilder(wb, plotData).build();
    Drawing<?> drawing = sheet.createDrawingPatriarch();
    ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
    Chart chart = drawing.createChart(anchor);
    ChartAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
    ChartAxis leftAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);
    ScatterChartData scatterChartData = chart.getChartDataFactory().createScatterChartData();
    ChartDataSource<String> xs = DataSources.fromStringCellRange(sheet, CellRangeAddress.valueOf("A1:J1"));
    ChartDataSource<Number> ys = DataSources.fromNumericCellRange(sheet, CellRangeAddress.valueOf("A2:J2"));
    ScatterChartSeries series = scatterChartData.addSerie(xs, ys);
    assertNotNull(series);
    assertEquals(1, scatterChartData.getSeries().size());
    assertTrue(scatterChartData.getSeries().contains(series));
    chart.plot(scatterChartData, bottomAxis, leftAxis);
    wb.close();
}
Also used : SheetBuilder(org.apache.poi.ss.util.SheetBuilder) ScatterChartData(org.apache.poi.ss.usermodel.charts.ScatterChartData) XSSFWorkbook(org.apache.poi.xssf.usermodel.XSSFWorkbook) Workbook(org.apache.poi.ss.usermodel.Workbook) ScatterChartSeries(org.apache.poi.ss.usermodel.charts.ScatterChartSeries) ClientAnchor(org.apache.poi.ss.usermodel.ClientAnchor) ChartAxis(org.apache.poi.ss.usermodel.charts.ChartAxis) XSSFWorkbook(org.apache.poi.xssf.usermodel.XSSFWorkbook) Sheet(org.apache.poi.ss.usermodel.Sheet) Chart(org.apache.poi.ss.usermodel.Chart) Test(org.junit.Test)

Aggregations

ScatterChartSeries (org.apache.poi.ss.usermodel.charts.ScatterChartSeries)2 Chart (org.apache.poi.ss.usermodel.Chart)1 ClientAnchor (org.apache.poi.ss.usermodel.ClientAnchor)1 Sheet (org.apache.poi.ss.usermodel.Sheet)1 Workbook (org.apache.poi.ss.usermodel.Workbook)1 ChartAxis (org.apache.poi.ss.usermodel.charts.ChartAxis)1 ScatterChartData (org.apache.poi.ss.usermodel.charts.ScatterChartData)1 SheetBuilder (org.apache.poi.ss.util.SheetBuilder)1 XSSFWorkbook (org.apache.poi.xssf.usermodel.XSSFWorkbook)1 Test (org.junit.Test)1