Below are the steps required for creating a basic chart in Microsoft Excel and Sun OpenOffice Calc.
Open Excel or Calc and the document for the chart.
Highlight the values 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.
In Excel 2003 and earlier, click the Insert menu at the top of the window and select Chart to bring up the chart wizard. The chart wizard will step you through the procedure for creating the chart, including the types you want to use, the title, axis, legends, etc.
In Excel 2007 and later, click on the Insert tab and in the Charts section, select the chart type and style of chart. The chart will be added to the spreadsheet and you can modify the style and color, add or remove chart elements, and filter the data that is displayed in the chart.
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.