How to Make a Graph in OpenOffice Calc

Written by aubrey kerr
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Graph in OpenOffice Calc
Create professional graphs in OpenOffice Calc (Jupiterimages/Goodshoot/Getty Images)

Calc is the OpenOffice spreadsheet program. Enter data into Calc and make charts using the OpenOffice 3 Chart Wizard. Earlier versions of OpenOffice have an AutoFormat Chart window that works in a similar way. Make Calc charts for any spreadsheet data. For example, make a chart to show your expenditures over time or the amount of rainfall per year.

Skill level:


  1. 1

    Enter your data into a Calc spreadsheet.

  2. 2

    Click on the "Charts" button in the top toolbar, it looks like a little column chart, or navigate to "Insert" > "Chart...." The Chart Wizard or AutoFormat window will open.

  3. 3

    Select a chart type in the Chart Wizard. Basics like Column, Bar, Pie and Line are available. There's also more specialised charts like XY (Scatter), Bubble, Net, Stock and a chart that combines Column and Line. A chart preview displays when you click each type.

  4. 4

    Check "3D Look" if desired. Not all chart types support 3D styling. Click "Next."

  5. 5

    Enter the data range for your chart. Select some or all of your data. Click "Next."

  6. 6

    Customise data by column. This step allows you to more finely tune your data selection. Remove columns from your chart or leave the default settings to include all data. Select "Next" for the final set-up screen.

  7. 7

    Add a title, subtitle and axis labels. Choose which grid lines to display and where you want the legend to appear. Your selections will update in the preview window.

  8. 8

    Click "Finish" to create the chart. It will appear to the right of your data. Click on the chart to move it. Drag the corners to make it larger or smaller.

  9. 9

    Use the AutoFormat window if you have an older version of Calc. When the window opens click "new sheet" and "Next."

  10. 10

    Select a chart type. A sample will open to the left instead of a preview. Make your grid line and data series selections in this second window then click "Next."

  11. 11

    Give the chart and axis lines titles and click "Create." There are fewer options available in the AutoFormat window, but you can make some adjustments when the chart is created.

  12. 12

    Double-click the chart and go to "Format." Choose "Chart Wall" or "Grid" to create fills and change background and line colours. Click outside the chart to deselect it; your changes are automatically saved.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.