Bug 59623

Summary: Threshold lines(Target values) cannot be created in all chart types in word, excel and ppt
Product: POI Reporter: Chenna Kesavarao <chennak.s>
Component: XDDFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: enhancement    
Priority: P2    
Version: 3.14-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Chenna Kesavarao 2016-05-24 11:30:15 UTC 
https://confluence.dimagi.com/pages/viewpage.action?pageId=29559951
This link shows how to set a target value in excel. We need to achieve this threshold for a particular value through POI.

The threshold will target a particular value or it will highlight between range of values.
Comment 1 Dominik Stadler 2016-05-24 12:54:24 UTC 
As http://poi.apache.org/spreadsheet/limitations.html states, charting is not fully implemented and there is currently no major effort underway to add it. 

If you really need functionality and have the skills, your best option will be to work out a patch together with some unit-tests which we then can discuss on and apply if it fits.

Another option might be to find out what actual XML-conent is needed for these things and use the low-level getCT... methods and CT... classes to add these items in your code.
Comment 2 Chenna Kesavarao 2016-06-06 14:45:09 UTC 
microsoft is not yet providing support for this feature
Comment 3 Alain Fagot Bearez 2018-02-12 13:45:56 UTC 
Despite not having a one-method solution for this, all underlying constructs are available. The recently introduced package XDDF offers bar charts (where an option is given to set the direction to columns) and scatter charts to draw the line.

I suppose you could write an example using these resources as part of our ongoing documentation effort.
Comment 4 Alain Fagot Bearez 2019-12-02 00:26:41 UTC 
I would consider the following example as an answer to this issue:

/examples/src/org/apache/poi/xssf/usermodel/examples/ExcelChartWithTargetLine.java