Edit Article

Edited by Vivek Kumar Rohra, Anita K. Moore, Rob S, Ben Rubenstein and 25 others

To quickly create a graph in a spreadsheet, perform the following steps.

Ad

EditSteps

  1. Create a Graph Using a Spreadsheet Step 1.jpg
    1
    Enter your data into the spreadsheet in a table format.
    • Table Format:
    • Box 1-a is the x-axis (generally put any sort of time on this axis).
    • Box 1-b is y-axis.
    • Information for the x-axis is placed in boxes 2-a to infinity-a.
    • Information for the y-axis is placed in boxes 2-b to infinity-b.
    Ad
  2. Create a Graph Using a Spreadsheet Step 2.jpg
    2
    Select the cells that contain the information that you want to appear in the bar graph. If you want the column labels and the row labels to show up in the graph, ensure that those are selected also.
  3. Create a Graph Using a Spreadsheet Step 3.jpg
    3
    Press the F11 button on your keyboard. This will create your bar graph on a "chart sheet." A chart sheet is basically a spreadsheet page within a workbook that is totally dedicated to displaying your graph.
  4. Create a Graph Using a Spreadsheet Step 4.jpg
    4
    Use the Chart wizard Click insert then chart, if F11 doesn't work. In Gnumeric it won't work. Choose Chart Type.
    • Choose a data range.
    • Choose a data series.
    • Choose chart elements.
  5. Create a Graph Using a Spreadsheet Step 5.jpg
    5
    On the Chart toolbar, which appears after your chart is created, click on the arrow next to the Chart Type button and click on the Bar Chart button..
  6. Create a Graph Using a Spreadsheet Step 6.jpg
    6
    You can also create a pie chart.
    Ad


Add your own method
Save

EditVideo



EditTips

  • To add more detail to the bar graph click on the Chart Wizard on the Standard toolbar and fill in the necessary information.
  • To make a chart title as an element of the graph, click once in the chart area of the graph and click on the Chart Wizard button on the Standard Toolbar. Click Next until you get to Step 3 - Chart Options. In the Chart Title field, type the chart title and click on Finish.
Ad

EditThings You'll Need

  • Computer
  • Spreadsheet software such as Microsoft Excel, OpenOffice.org Calc, iWork Numbers or Gnumeric.
  • Data that contains categories and numeric figures

EditRelated wikiHows

How to
Use Voicenet to Receive Reminders via Telephone

How to
Read a Binary Clock

How to
Make a Maze Using a Word Processor

How to
Make a Shared Spreadsheet

Article Info

Categories: Spreadsheets

Recent edits by: Monica, Peter, Leona

In other languages:

Español: Cómo crear un gráfico usando una hoja de cálculo, Italiano: Come Creare un Grafico Utilizzando un Foglio di Calcolo Elettronico, Português: Como Criar um Gráfico Usando uma Planilha, Русский: создать график с помощью электронной таблицы

Ad

Thanks to all authors for creating a page that has been read 134,367 times.

Was this article accurate?

YesNo

Contribute
to wikiHow!

Edit this article