How to create a chart or graph in Excel, Calc, or Sheets

Updated: 09/03/2019 by Computer Hope
Column chart

Charts and graphs can help illustrate important information needing to be conveyed to other people. Common examples of data displayed in a chart are sales information for a month or year or showing trends in the stock market.

To create or edit a chart or graph in Microsoft Excel, LibreOffice Calc, or Google Sheets, select a link below and follow the provided steps.

Create a chart in Microsoft Excel

To create a chart in Microsoft Excel, follow the steps below for your version of Excel.

Excel 2007 and later

  1. Open Microsoft Excel and create a new spreadsheet or open an existing spreadsheet where you want to add a chart.
  2. Highlight the cells containing the data you want to use to create the chart. For example, if you want to chart the sales data listed in cells A20 through J20, you would highlight A20 through J20.
  3. In the Ribbon, click the Insert tab.
  4. In the Charts section, select the type and style of chart you want to create. Once added, you can modify the style and color, add or remove chart elements, and filter the data that is displayed in the chart.

Create chart in Microsoft Excel

Excel 2003 and earlier

  1. Open Microsoft Excel and create a new spreadsheet or open an existing spreadsheet where you want to add a chart.
  2. Highlight the cells containing the data you want to use to create the chart. For example, if you want to chart the sales data listed in cells A20 through J20, you would highlight A20 through J20.
  3. Click the Insert menu at the top of the Excel program window.
  4. Select Chart in the Insert menu to open the chart wizard. The chart wizard steps you through the process to create a chart, including the types you want to use, the title, axis, legends, etc.

Create a chart in LibreOffice Calc

  1. Open LibreOffice Calc, then create a new spreadsheet or open an existing spreadsheet where you want to add a chart.
  2. Highlight the cells containing the data you want to use to create the chart. For example, if you want to chart the sales data listed in cells A20 through J20, you would highlight A20 through J20.
  3. Click the Insert menu at the top of the Calc program window.
  4. Select Chart in the Insert menu to open the chart wizard. The chart wizard steps you through the process to create a chart, including the types you want to use, the title, axis, legends, etc.

Screenshot: LibreOffice Calc Chart Wizard.

Create a chart in Google Sheets

  1. Go to the Google Sheets website at sheets.google.com.
  2. Open or create a spreadsheet.
  3. Select the range of cells with the desired data.
  4. Select Insert from the menu bar.
  5. Select Chart.
  6. Use the Chart editor to change the chart type, and customize aspects of the chart.

Edit an existing chart

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

Additional information