OO graphing

From WikiEducator
Jump to: navigation, search

Example Figure

The figure below was created in Open Office using junk data and the procedure in this page below the graph.


Follow the procedure to create your graph once enough participants have completed their row in the data table .

Creating an XY scatter plot in Open Office Calc for upload to WikiEducator

Icon activity.jpg Activity
  • Copy data and heading from the data table in the wiki while you are in the 'edit mode
  • Open Open Office Calc
  • Choose Paste Special -> unformatted text
  • Uncheck Separated by tab checkbox
  • Check Separated by comma checkbox
  • Click ok if things are looking good
  • Highlight data and headings in columns 2 and 3 only
  • Go to the Insert menu and click Chart
  • Choose XY scatter for the chart type
  • Click Next
  • Click Next for data range
  • Click Next for data series
  • Add a title
  • Add an X-axis label
  • Add a Y-axis label
  • Uncheck Display legend
  • Click Finish
  • Click on Data points so they are highlighted
  • Right click in graph area and choose Insert trend line
  • Choose Type tab
  • Confirm the trend line type is linear
  • Check Show equation and Show R2 boxes
  • Click OK
  • Move the chart so that it is locked(you should see the anchor symbol) and highlighted
  • Copy chart
  • Open Open Office Impress
  • Choose empty presentation
  • Choose Paste Special -> Star Object Descriptor (XML)
  • Resize chart
  • Export as a portable network graphics (.png) image to your local computer
  • Upload the file to WikiEducator
  • Add chart to the Analysis page.