I have a Sheet onto which I add a line every week to record certain numbers in various category (columns).
I would like to have a Pie chart display the current status of those categories. This means the pie chart should automatically use the last filled row of the spreadsheet.
Is that possible ?
I was planning to use something along the lines of :
but I can't use formulas in the Pie Chart data source.