0

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 :

{index(Sheet!A:A;max(row(Sheet!A:A)*(Sheet!A:A<>"")));index(Sheet!B:B;max(row(Sheet!B:B)*(Sheet!B:B<>"")))}

but I can't use formulas in the Pie Chart data source.

  • 1
    Welcome to Web Applications. Use your formula in a cell, then make set the source for your chart to point to the range that displays the formula results. – Rubén Jan 6 at 2:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.