How do I create a chart or graph in Excel or Calc?

Creating a chart

Below are the steps required for creating a basic chart in Microsoft Excel and Sun OpenOffice Calc.

1. Open Excel or Calc and the document for the chart.
2. Highlight the values of you want to chart. For example, if you want to chart the months totals that are listed in cells A20 through J20 you would highlight A20 through J20.
3. Once highlighted click Insert at the top of the window and select Chart to bring up the chart wizard.
4. The chart wizard will step you through the proceedure for creating the chart, including the types you want to use, the title, axis, legends, etc.

Editing an existing chart

If a chart already exists in the document you are editing you can change any of the chart properties by double-clicking on the portion of the chart you want to edit. For example, double-clicking the chart allows you to customize the colors, lines, and background values of the chart.