How can I change charts generated by apache poi to not use smoothed lines and show empty cells as gaps?

by

Thanks to Etienne for the code to set blanks as gaps. I got help from a POI developer and here is the solution that solves both issues mentioned in the original question.

    XSSFChart chart = (XSSFChart)drawing.createChart(anchor);

    // this will set blank values as gaps in the chart so you 
    // can accurately plot data series of different lengths
    CTDispBlanksAs disp = CTDispBlanksAs.Factory.newInstance();
    disp.setVal(STDispBlanksAs.GAP);
    chart.getCTChart().setDispBlanksAs(disp);


    // setup chart, axes, data series, etc


    chart.plot(data, new ChartAxis[] { bottomAxis, leftAxis });

    // this must occur after the call to chart.plot above
    CTPlotArea plotArea = chart.getCTChart().getPlotArea();
    for (CTLineChart ch : plotArea.getLineChartList()) {
        for (CTLineSer ser : ch.getSerList()) {
            CTBoolean ctBool = CTBoolean.Factory.newInstance();
            ctBool.setVal(false);
            ser.setSmooth(ctBool);
        }
    }

More Related Contents:

  1. Apache POI add a Series name into LineChart
  2. Apache poi Excel line chart points
  3. How to set axis’ labels in a Line Chart using Apache Poi
  4. Create Bar Chart in Excel with Apache POI
  5. Apache POI Line Chart colors
  6. What does the statement Object[][] data = new Object [][] mean?
  7. Get Cell Value from Excel Sheet with Apache Poi
  8. Writing a large resultset to an Excel file using POI
  9. Best language to parse extremely large Excel 2007 files [closed]
  10. How to read Excel cell having Date with Apache POI?
  11. Replacing a text in Apache POI XWPF
  12. Getting Exception(org.apache.poi.openxml4j.exception – no content type [M1.13]) when reading xlsx file using Apache POI?
  13. How to draw multiple axis on a chart using JAVAFX Charts
  14. Password Protected Excel File
  15. Get the cell value as how it was presented in excel
  16. Trying to make simple PDF document with Apache poi
  17. Error While Reading Large Excel Files (xlsx) Via Apache POI
  18. Read data from CSV file into ArrayList and display in XY Chart
  19. how to add a picture to a .docx document with Apache POI XWPF in java
  20. Creating a Table of Contents for a XWPFDocument with page numbers’ indication
  21. How to convert HSSFWorkbook to XSSFWorkbook using Apache POI?
  22. Apache POI evaluate formula
  23. Convert Word to HTML with Apache POI
  24. Java JFreeChart Category Step Chart horizontal (image to explane)
  25. Java POI the supplied data appears to be in the Office 2007+ XML
  26. Determine MS Excel file type with Apache POI
  27. Libraries for pretty charts in SWT? [closed]
  28. Limitation while generating excel drop down list with Apache POI
  29. Reading data from xlsx with Apache POI’s SXSSFSheet
  30. POI DataFormatter returns 2 digits year instead of 4 digits year for date cells [duplicate]

Leave a Comment