.
...
7. Click in the Series Values box and then select C5C7. Then click OK.
This will put the formula =Sheet1!$C$7 as the formula for the series values. When ExcelWriter inserts data, this formula will expand to include the new rows, so all the top 5 expenses data will be included in the chart series.
...