Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Entropy
Lv 7
Entropy asked in Computers & InternetSoftware · 7 months ago

In LibreOffice, how to get a chart or summary section to expand with the data?

I have a spreadsheet with a data sheet, a charts sheet, and a summary sheet.  As I add data, I want the chart to reflect it and the summary formulae to reflect it.

But the data ranges all have a defined start and end in the chart, and my formulae (e.g. =AVERAGE(A4:A19)).  As a result, everytime I past a new row in, I have to manually update the extent of the data ranges in the chart and the formulae.

How can I tell the formula (and the charts) to include all cells in the column (starting with A4 for example) until the data stops.   I've seen other spreadsheets do this.  I'm sure I'm doing something wrong.

2 Answers

Relevance
  • Anonymous
    4 months ago

    Go to school .

  • David K
    Lv 6
    7 months ago

    Insert the new rows within the range of the formula, not at the end.

Still have questions? Get answers by asking now.