I am using aspose cells for java aspose-cells-188.8.131.52.
I have a chart which has a title. I want the chart title to be dynamic. It should refer a cell in the worksheet and whenever the value of the cell changes the title should update.
In MS excel 2007 it is possible manually. Here are the steps to create in MSexcel.
create a chart–>show the title–>click on the title --> type the refererenced cell in the formula bar.
Attached a sample file which has this functionality.