wikiHow to Create a Graph Using a Spreadsheet

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

Steps

  1. Image titled Create a Graph Using a Spreadsheet Step 1
    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.
  2. Image titled Create a Graph Using a Spreadsheet Step 2
    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. Image titled Create a Graph Using a Spreadsheet Step 3
    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. Image titled Create a Graph Using a Spreadsheet Step 4
    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. Image titled Create a Graph Using a Spreadsheet Step 5
    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. Image titled Create a Graph Using a Spreadsheet Step 6
    6
    You can also create a pie chart.

Tips

  • 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.

Things You'll Need

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

Article Info

Categories: Spreadsheets