sheet.charts.add(type, source, seriesBy) makes a chart over a block of cells, as Insert Chart does in Microsoft Excel. Labels in the first row and column become series names and categories. The chart reads its cells, so it follows later edits.
type is an Excel.ChartType name: "ColumnClustered", "BarClustered", "Line", "Pie", "XYScatter" and so on. seriesBy is "Auto", "Rows" or "Columns".