Hi,
I tried introducing green strip using text box in x axis and yaxis . The 'X-Axis' green text box height should be (0,0) to ( 0, -5) and 'X-Axis' green text box width (0,0) to (0,-5).But i get some misalignment.I have attached the code snippet and Required foamat in excel along with this and also find the current excel file we obtain.Please help me out to resolve this issue.
int chartIndex = ws.getCharts().add(ChartType.SCATTER, 3, 9, 27, 19);
int y = ws.getCharts().get.getPlotArea().getHeight();
int x = ws.getCharts().get.getPlotArea().getWidth();
int width = (new Double(((5*x)/(info.getMaxSERangeRow()*2)))).intValue();
int height = (new Double(((5*y)/(info.getMaxMSRangeRow()*2)))).intValue();
TextBox yGreenBox = ws.getCharts()..get(0.getShapes().addTextBoxInChart(450, (x / 2) - width + 250 ,(y / 2) , width);
TextBox xGreenBox = ws.getCharts().get(0).getShapes().addTextBoxInChart((y / 2) + 450, (x / 2) + 250, height, (x / 2));
Thanks & Regards,
Geetha