Spreadsheets do a little bit of a lot, so it often feels unnecessary to look for other sorts of tools with which to work with data. The way they are part of suites of tools – such as OpenOffice and Microsoft Office – is also very helpful, since it makes exchanging information between spreadsheets and word processors, or presentation tools easier. Charts are updated automatically if you change the data.Ī great advantage of spreadsheet applications like Calc and Excel is the huge range of capabilities they have all in one place. You can change the size, type, colour and labelling of the visualisations you create. Calc's tools for making graph and charts are quite easy to use. It can open and edit Excel files and several other formats. The most widely-used spreadsheet is Microsoft Excel, and OpenOffice Calc comes with a fairly similar range of capabilities. Spreadsheets also help you understand your data by enabling you to create different types of charts using your data, including line charts, pie charts and block histograms. This data can be re-arranged, sorted and processed using lots of different mathematical formulas to answer questions that can help us make decisions or learn something about an issue. Spreadsheets store numbers, dates and text in tables, which are lots of cells arranged into rows (across) and columns (vertically).

Home | About OpenOffice.This is a spreadsheet application to create, store and analyse any kind of data, whether it's financial information about your organisation or a list of companies fined for violating environmental laws. Now you can enter new data, or copy current data into the new row or column on the spreadsheet. A new blank column will appear to the left of the column that was originally selected. Left-Click the Insert menu and select Column.

To add a column to the spreadsheet, select any cell in the column to the right of where the new column will be. A new blank row will appear above the row that was originally selected. Left-click the Insert menu and select Rows.

To add a row to the spreadsheet, select any cell in the row below where the new row will be. This section will describe how to do this. defines a series for graphing based on the layout of the users data.

Openoffice calc graph add data