How to make a graph or chart with Sheets, Calc, or Excel

I would like to say hi!

The necessity to communicate essential information to others is illustrated via charts and graphs.
Sales data for a month or year, or stock market patterns, are typical examples of data that is shown in a chart.

Follow the instructions below and adhere to create or modify a chart or graph in Google Sheets, LibreOffice Calc, or Microsoft Excel.

Microsoft Excel

Use the methods below according to your version of Excel to create or plot a chart in a spreadsheet.

Microsoft Excel 2007 version and newer

  1. Create a new spreadsheet in Microsoft Excel or open an existing one if you wish to add a chart.
  2. To utilize the data for the chart, highlight the cells that contain it.
    For instance, you would highlight cells B10 through G10 if you wanted to graph the information contained in those cells.
  3. Click the Insert tab in the Ribbon.
  4. Choose the kind and design of the chart you wish to create under the Charts section.
    Pie, waterfall, and column charts are a few types of diagrams.
    After adding, you may change its look and color, add or delete chart components, and filter the information that is shown in the chart.

Microsoft Excel 2003 version and older

  1. Create a new spreadsheet in Microsoft Excel or open an existing one if you wish to add a chart.
  2. To utilize the data for the chart, highlight the cells that contain it.
    For instance, you would highlight cells B10 through G10 if you wanted to graph the information contained in those cells.
  3. At the top of the Excel program window, select Insert.
  4. To launch the chart wizard, choose Chart from the Insert menu.
    The chart wizard guides you through the creation of a chart, helping you choose the types, titles, axis, legends, and other elements.

LibreOffice Calc

  1. Open an existing spreadsheet or start a new one in LibreOffice Calc and add a chart there.
  2. To utilize the data for the chart, highlight the cells that contain it.
    For instance, you would highlight cells B10 through G10 if you wanted to graph the sales information contained in those cells.
  3. At the top of the Calc application window, select Insert.
  4. To launch the chart wizard, choose Chart from the Insert menu.
    The chart wizard guides you through the creation of a chart, helping you choose the types, titles, axis, legends, and other elements.

Google Sheets

  1. Visit sheets.google.com to access the Google Sheets webpage.
  2. Open a spreadsheet or make one.
  3. Choose the cells that contain the required data range.
  4. Click Insert.
  5. Choose Chart.
  6. To alter the type of the chart and add customizations, use the Chart Editor.

Edit a chart

By double-clicking the area of the chart you wish to alter, you may change its layout or characteristics if a chart already exists in the spreadsheet you are working on.
You may change the chart’s colors, lines, and background values by double-clicking it.