Version 1 (modified by hudson, 13 years ago) (diff)

Added text body to page.

Loading a .csv file as a graph using Open Office

Many files used by ANUGA are in the .csv format. With a little input from the user, these can be loaded as a spreadsheet in Open Office, or Excel, in Windows or Linux (Ubuntu in this example). The method is very similar for both applications and platforms, but the steps illustrated here use the freely-available Open Office spreadsheet application.

Open a CSV file

If you are using Ubuntu, it will automatically open .csv files using Open Office. If you are using windows, you may need to right-click on the .csv file, and then select the "Open With..." option, and choose Microsoft Excel.

Set formatting options

There is no common standard for .csv files, so you will need to tell the application a bit of information to help it open the file. Make sure the "comma" and "space" checkboxes in the "Separated by" box are both checked. Click OK to continue.

Create a chart

You should see the timeseries data in 2 columns. Now go to the menu and select "Insert/Chart?..."

Choose a chart type

Choose the "X/Y (Scatter)" chart type. Select "Lines Only".

Add some labels to the chart

Select "4. Chart Elements" to add some labels. Uncheck "Display Legend". You can check how your graph looks as you proceed. When you are happy with your graph, click "Finish".


You can now resize your graph, copy it to another program, or print it. If you want to change the line thicknesses of the graph or other visual styles, right click on the line you wish to change and choose an option to modify.

Attachments (6)

Download all attachments as: .zip