Created attachment 33752 [details] Excel file with chart Shifting rows that are part of a chart's data series does not shift the data series cell references.
Created attachment 33753 [details] SimpleScatterChart.xls
Tried to write a unit test for this, then discovered XSSFChart is pretty incomplete. Without using the CTChart* classes, it is possible to add data series to a chart but not query existing data series. /lang=jython from java.io import File from org.apache.poi.ss.usermodel import WorkbookFactory f = File('SimpleScatterChart.xlsx') wb = WorkbookFactory.create(f, None, True) sheet1 = wb.getSheet('Sheet1') chart1 = wb.getSheet('Chart1') sheet1scatter = sheet1.createDrawingPatriarch().getCharts()[0] chart1scatter = chart1.createDrawingPatriarch().getCharts()[0]