How to Create a Graph Using a Spreadsheet
To create a graph using a spreadsheet, you'll need to enter your data into the spreadsheet in table form, select the cells containing that data, and navigate to the program's Chart Wizard using a toolbar button or menu option. From there, select the type of chart you want and follow the program's on-screen instructions to complete it.
Steps
-
1Enter 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.
-
2Select 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. -
3Press 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. -
4Use 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.
-
5On 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.. -
6You can also create a pie chart.
Community Q&A
-
How do I add a 2D pie chart to my 2D line chart in my spreadsheet?wikiHow ContributorIn Excel: 1.) Select the data that you want in your chart. 2.)Go to Insert > Recommended Charts. 3.) After you click "Recommended Charts," a box should show up. That box will list pie and line charts for you to choose from.
-
If I want to create a spreadsheet representing modulus of permeability (conductivity) of some layers and their effect on uplift forces under water structure, what steps should I take?
-
How do I make the legend update as I change the graph?
-
How do I add another column to the bar graph?
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
EditRelated wikiHows
Article Info
Categories: Spreadsheets
In other languages:
Español: crear un gráfico usando una hoja de cálculo, Italiano: Creare un Grafico Utilizzando un Foglio di Calcolo Elettronico, Português: Criar um Gráfico Usando uma Planilha, Русский: создать график с помощью электронной таблицы, Deutsch: Mit einer Tabellenkalkulation ein Diagramm erstellen
Thanks to all authors for creating a page that has been read 314,276 times.
