How to set axis’ labels in a Line Chart using Apache Poi

by

try use this method. 

public static void setAxisTitle(XSSFChart chart, int axisIdx, String title) {
    CTValAx valAx = chart.getCTChart().getPlotArea().getValAxArray(axisIdx);
    CTTitle ctTitle = valAx.addNewTitle();
    ctTitle.addNewLayout();
    ctTitle.addNewOverlay().setVal(false);
    CTTextBody rich = ctTitle.addNewTx().addNewRich();
    rich.addNewBodyPr();
    rich.addNewLstStyle();
    CTTextParagraph p = rich.addNewP();
    p.addNewPPr().addNewDefRPr();
    p.addNewR().setT(title);
    p.addNewEndParaRPr();
}

More Related Contents:

  1. Apache POI add a Series name into LineChart
  2. Apache poi Excel line chart points
  3. Create Bar Chart in Excel with Apache POI
  4. Apache POI Line Chart colors
  5. How can I read numeric strings in Excel cells as string (not numbers)?
  6. Best language to parse extremely large Excel 2007 files [closed]
  7. How to read Excel cell having Date with Apache POI?
  8. Embed files into Excel using Apache POI
  9. Apache POI – FileInputStream works, File object fails (NullPointerException)
  10. Removing a row from an Excel sheet with Apache POI HSSF
  11. Apache POI autoSizeColumn Resizes Incorrectly
  12. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  13. Merging cells in Excel using Apache POI
  14. Password Protected Excel File
  15. how to read exact cell content of excel file in apache POI
  16. Excel Cell Style issue
  17. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  18. Exception when writing to the xlsx document several times using apache poi 3.7
  19. Apache-POI sorting rows in excel
  20. Java POI : How to read Excel cell value and not the formula computing it?
  21. Create a password protected Excel file using Apache POI?
  22. Apache POI evaluate formula
  23. Embed files into XSSF sheets in Excel, using Apache POI
  24. How can I change charts generated by apache poi to not use smoothed lines and show empty cells as gaps?
  25. Java POI the supplied data appears to be in the Office 2007+ XML
  26. Determine MS Excel file type with Apache POI
  27. Make column read-only using apache poi
  28. Replacing a text in Apache POI XWPF
  29. How to read data from XLS (Excel) file [Java, Android]
  30. Limitation while generating excel drop down list with Apache POI

Leave a Comment