OpenOffice Calc FAQ – Charts

  • How do I compute or plot trend lines?
  • How do I extend the range of data shown in my chart after I add new data to my spreadsheet?
  • How do I create a chart in a spreadsheet that is automatically updated when the data is changed?

How do I compute or plot trend lines?

 

First, You need a column on your spreadsheet to hold average values. Averages can be made by using one of these formulas:
=SUM(<cell range>/<number of cells>)
=AVERAGE(<cell range>)

Now, on to graphing:

You can do trendlines in Calc, but you can’t show the equation of the line. To do that you need to do a linear array function.

Trendline: You have to have an xy chart to make a trendline (change the chart type). When you have a chart, select the data points, and then right click and select ‘Object properties’. In the statistics tab, select the regression picture (none, linear, etc.) that you want.

For Version 1, OOCalc only really does linear.

How do I extend the range of data shown in my chart after I add new data to my spreadsheet?

 

  • Select a new range and drag the selection onto the chart, or
  • Select the chart, right-click, and then choose¬†Modify Data Range

 

How do I create a chart in a spreadsheet that is automatically updated when the data is changed?

 

When you create a chart based on data that is present in the same spreadsheet, the chart will automatically be updated whenever the data in the spreadsheet changes.