Insert ChartĬlick the Insert Chart,, icon on the Function Toolbar. That is plotted on the vertical (y) axis. Horizontal (x) axis of the chart, and the column on the right is the variable Spreadsheet programs typicallyĪssume that the column on the left is the variable that is plotted on the Into a '0'.) Drag-copy the formula all the way down to the 90 in the A column.ĭon't worry if you don't know what the numbers mean we aren't concerned (The 'B2' cell contents change from the formula '=SIN(A2)'

Ĭlick on the bottom right corner of the B2 cell.

(Ctrl+up arrow is a quick way to move up.) Line you drag over.) (The number 90 will be in cell A92) When you see a, click on it and drag it down until you see the tool tip number read 90 then release the click. (Put the cursor over the box at the bottom right corner of 'A2'. (Click on A2 again to select it.) Drag-copy A2 down until you see Click anywhere on the Spreadsheet to unselect “A2” Go to the bottom of your workbook and click on Sheet2. Since math is something that anyone can duplicate, we'll use Statistical divisions of a population, or divisions of an income that make Mathematical functions, stock market prices over time, rainfall over time,

The first thing you need is data that shows a relationship. The purpose of this tutorial is to teach basic spreadsheet skills Data Relationship In the preview you can see how the final chart will look.Tutorial donated by Wayne Tschirhard Purpose Use a semicolon as delimiter between ranges.Ĭlick one of the options for data series in rows or in columns.Ĭheck whether the data range has labels in the first row or in the first column or both. If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. In Calc, click Select data range to minimize the dialog, then drag over a cell area to select the data range. In Writer, an example data range would be 'Table1.A1:E4'.

'$Sheet1.A1:A5 $Sheet1.D1:D5' is also a valid data range. Note that a data range may consist of more than one region in a spreadsheet, e.g. In Calc, an example data range would be '$Sheet1.$B$3:$B$14'. Press Shift+F1 and point to a control to learn more about that control.

Openoffice calc graph add data