1) Any method to let jasperserver exported my chart on a specific area in a worksheet (like chart 1, ActiveSheet.ChartObjects.Add(5, 50, 520, 280))? Try the Excel API to see if there is something for this; http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/#xlsfeatures 2) I find in excel chart object, the vertical axis max and min value is auto generated, any method to let jasperserver use the same logic as in the origin excel chart? set a Max or Min property on the axis. You can either do this statically or dynicamically. For dynamic, you will need to create a variable you might want to make the variable 80% of the Max value or something i dunno, then pass the variable as the max/min axis setting. 3) in chart1 using marco, the image is on top of several row (4-20), but if using jasperserver to export the chart (chart2), the chart is on top of one row and that row is enlarged (row5). How to make the chart2 like chart1, on top of several rows instead of one row? Use the following property net.sf.jasperreports.export.xls.collapse.row.span = false
