Changes between Version 2 and Version 3 of AnugaExportCsv
- Timestamp:
- Jun 17, 2010, 5:13:43 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AnugaExportCsv
v2 v3 3 3 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. 4 4 5 == Open a CSV file ==5 == 1. Open a CSV file == 6 6 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. 7 [[Image(csv_0.png)]] 7 ||[[Image(csv_0.png)]]|| 8 ---- 8 9 9 == Set formatting options ==10 == 2. Set formatting options == 10 11 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. 11 [[Image(csv_1.png)]] 12 ||[[Image(csv_1.png)]]|| 13 ---- 12 14 13 == Create a chart ==15 == 3. Create a chart == 14 16 You should see the timeseries data in 2 columns. Now go to the menu and select "Insert/Chart..." 15 [[Image(csv_2.png)]] 17 ||[[Image(csv_2.png)]]|| 18 ---- 16 19 17 == Choose a chart type ==20 == 4. Choose a chart type == 18 21 Choose the "X/Y (Scatter)" chart type. Select "Lines Only". 19 [[Image(csv_3.png)]] 22 ||[[Image(csv_3.png)]]|| 23 ---- 20 24 21 == Add some labels to the chart ==25 == 5. Add some labels to the chart == 22 26 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". 23 [[Image(csv_4.png)]] 27 ||[[Image(csv_4.png)]]|| 28 ---- 24 29 25 == Finished! ==30 == 6. Finished! == 26 31 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. 27 [[Image(csv_5.png)]] 32 ||[[Image(csv_5.png)]]|| 28 33 29 The process is similar in Excel. 34 ----