wikiHow to Create a Graph Using a Spreadsheet

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

StepsEdit

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.
Can you please put wikiHow on the whitelist for your ad blocker? wikiHow relies on ad money to give you our free how-to guides. Learn how.
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
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
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
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
You can also create a pie chart.

Ad

Advertisement

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?

Answer
How do I make the legend update as I change the graph?

Answer
How do I add a 2D pie chart to my 2D line chart in my spreadsheet?

Answer

Ask a Question

Submit

To add more detail to the bar graph click on the Chart Wizard on the Standard toolbar and fill in the necessary information.

3 Helpful? 1
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.

3 Helpful? 1

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