I’m receiving an exception when I attempt to set the SpreadChart.CategoryFormula property to a formula whose data does not start at row 0. Attached is a sample application. Click the “success” button and the chart generates just fine. Click the “fail” button and it adds some rows above the data used in the chart but then fails on the formula. I am attempting to adjust the formula to account for the data not starting in the first row of the Spread. Ultimately I want to have multiple sets of data and grids on a single sheet going down.