Changes between Version 1 and Version 2 of AnugaExportCsv


Ignore:
Timestamp:
Jun 17, 2010, 7:07:50 AM (7 years ago)
Author:
hudson
Comment:

Added images.

Legend:

Unmodified
Added
Removed
Modified
  • AnugaExportCsv

    v1 v2  
    1 = Loading a .csv file as a graph using Open Office=
     1= Loading a .csv file as a graph using Open Office =
    22
    33Many 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.
     
    55== Open a CSV file ==
    66If 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.
     7[[Image(csv_0.png)]]
    78
    89== Set formatting options ==
    910There 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.
     11[[Image(csv_1.png)]]
    1012
    1113== Create a chart ==
    1214You should see the timeseries data in 2 columns. Now go to the menu and select "Insert/Chart..."
     15[[Image(csv_2.png)]]
    1316
    1417== Choose a chart type ==
    1518Choose the "X/Y (Scatter)" chart type. Select "Lines Only".
     19[[Image(csv_3.png)]]
    1620
    1721== Add some labels to the chart ==
    1822Select "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".
     23[[Image(csv_4.png)]]
    1924
    2025== Finished! ==
    2126You 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.
     27[[Image(csv_5.png)]]
     28
     29The process is similar in Excel.