Use tables and graphs to display spreadsheet data to your audience. Tables and graphs can be created with spreadsheet software. This software may be available on your computer or online at no charge. Microsoft Excel (available for free trial downloads), OpenOffice and Google have software that you can use to create tables and graphs. The graph can be generated by the data from the table. By using these two features together, they will up linked and updates will be displayed as the table data changes.
Instructions
Excel 2010
- 1
Open Excel 2010 and "Click" cell "A1." Type "Categories." In cell "A2," type "Home." Press the "Enter" key. In cell "A3," type "Office." Press the "Enter" key. In cell "A4"," type "Abroad." Using the keyboard, move the cursor to cell "B1." In cell "B1," type "Amount." Press "Enter." Type "120" in cell "B2," "160" in cell "B3" and "76" in cell "B4."
2Review your table data. Highlight cells "A1" to "B4." The highlighted area turns blue.
3Select the "Insert" tab and locate the "Charts" group. Select a graph from this group. For example, if you want to create a bar graph, select "Bar." A drop-down list appears. Select "Clustered Bar." A clustered bar graph is created.
Google Documents
- 4
Access the Google Documents website. Click "Create New." A drop-down list appears. Select "Spreadsheet." "Click" cell "A1." Type "Categories." In cell "A2," type "Home." Press the "Enter" key. In cell "A3," type "Office." Press the "Enter" key. In cell "A4," type "Abroad." Using the keyboard, move the cursor to cell "B1." In cell "B1," type "Amount." Press "Enter." Type "120" in cell "B2," "160" in cell "B3" and "76" in cell "B4."
5Review your table data. Highlight rows "1" to "4." The highlighted area turns blue.
6Select "Insert" on the menu bar, then "Chart." Review the recommended charts on the "Start" tab. Select one of them. A graph is quickly created in your document.
OpenOffice
- 7
Open OpenOffice Calc. A new spreadsheet appears. "Click" cell "A1." Type "Categories." In cell "A2," type "Home." Press the "Enter" key. In cell "A3," type "Office." Press the "Enter" key. In cell "A4," type "Abroad." Using the keyboard, move the cursor to cell "B1." In cell "B1," type "Amount." Press "Enter." Type "120" in cell "B2," "160" in cell "B3" and "76" in cell "B4."
8Review your table data. Highlight rows "1" to "4." The highlighted area turns blue.
9Select "Insert" on the menu bar. Select "Chart." The AutoFormat Chart dialog box appears. Select "Next." Select the chart type and click "Next." Check "Chart Title" and type a name for your chart. Click "Create." The chart appears in your OpenOffice Calc spreadsheet.
How to Create a Table & Graph for Free eHow
www.ehow.com/how_7619322_create-table-graph.htmlBy Emmanuelle DouglasUse tables and graphs to display spreadsheet data to your audience. Tables and graphs can be created with spreadsheet software. This software may be available on your ...
How to Create Tables and Graphs eHow
www.ehow.com/how_8033872_create-tables-graphs.htmHow to Create a Table & Graph for Free. Use tables and graphs to display spreadsheet data to your audience. Tables and graphs can be created with spreadsheet software.
Create a Graph Classic-NCES Kids' Zone - National Center for ...
nces.ed.gov/nceskids/graphing/ClassicHow about Creating your own Graph ... How about Creating your own Graph? Really. See for yourself; it's easy to create and even print ... Download a free ...
Using Excel to Create a Chart or Graph at Internet 4 Classrooms
www.internet4classrooms.com/excel_create_chart.htmUse our Tutorial on Microsoft Excel to Create a Chart or Graph at Internet 4 Classrooms, internet resources for teachers and students, children and parents.
Create Chart - ChartGo - Online Graphing Fast, Easy and Free
www.chartgo.comChartGo - Create Charts Online Fast and Free. Online Graphing. Create Pie Charts, ... Create Chart . Create a graph online quickly. ChartGo is a graph maker tool.
Create A Graph - National Center for Education Statistics (NCES ...
nces.ed.gov/nceskids/createagraphEmail this graph HTML Text: to: You will be emailed a link to your saved graph project where you can make changes and print. ... Download a free copy now. ...
How To Create/Make Charts And Graphs Online For Free
www.addictivetips.com/internet-tips/how-to-createmake-charts-and...OnlineChartTool is a free online service that lets you make professional looking charts and graphs. ... Bar graph, Line graph, Area graph, Pie graph, XY graph, ...
Video: How to Make a Graph in Microsoft Excel eHow UK
www.ehow.co.uk/video_4973259_make-graph-microsoft-excel.htmlTo make a graph in Microsoft Excel, first create a table with pieces of data, ... with IT help from a software developer in this free video on computers.
Create a Graph Online - About Web Search - How to Find What You're ...
websearch.about.com/b/2005/11/12/create-a-graph-online.htm12/11/2005 You can create a graph online with the help of the National Center for ... * ChartGizmo is absolutely free ... dynamic data from html table on the ...
How to Make Bar Graphs & Data Tables eHow UK
www.ehow.co.uk/how_6057861_make-bar-graphs-data-tables.htmlGenerally, a bar graph is made from data entered into a table. Use graph paper to draw the graph by hand, ... How to Make a Line Graph From a Data Table.
Constructing Circle Graphs - Office of Institutional Research and ...
cstl.syr.edu/fipse/TabBar/BldCirc/BUILDCIR.HTMConstruct a circle graph from a table of information. Critically read circle graphs, ... To create a circle graph we need to determine the following:
Excel Charts and Graphs Tutorial - How to Make and Create in Excel ...
www.free-training-tutorial.com/charts-graphs.html... (graph) Adding chart titles: ... Make sure your data is organized in the correct layout: - It should have a table layout, ...
How to use data from a table to create a graph chart in excel ...
tips4pc.com/Excel-2007/how_to_use_data_from_a_table_to.htmHow to use your table data to make a graph chart in Excel? ... FREE COMPUTER TIPS NEWSLETTER. LIKE US ON FBOOK! BUILD YOUR OWN WEBSITE. Get a Deal on Web Hosting;
To make a data table. (Tables, Charts, And Graphs). - Free Online ...
www.thefreelibrary.com/To+make+a+data+table.+(Tables%2c+Charts%2c...27/09/2002 Free Online Library: To make a data table. (Tables, Charts, And Graphs) ... To make a line graph. (Tables, Charts, And Graphs). Topics: Data collection.
Frequency Table - Graph Generator - Excel - Resources - TES
www.tes.co.uk/teaching-resource/Frequency-Table-and-Graph...Feel free to adapt/share/enjoy! ... t do not wish to spend time teaching them how to make a graph in ... (Activity) Frequency Table - Graph Generator - Excel; Maths ...
Graph Templates - Cacti - The Complete RRDTool-based Graphing ...
www.cacti.net/downloads/docs/html/graph_templates.htmlThe first thing you should do is create graph items for this graph template, just like for a regular graph. One ... Table 13-4. Field Description: Graph Template Items.
Chart Software - Download Free to Make Presentation Charts & Graphs
www.smartdraw.com/specials/chart.htmClick simple commands and SmartDraw builds your chart or graph for you, automatically. ... for free! Use SmartDraw to create charts and graphs: Bar Charts; Pie Charts;
Online Graph Makers Passy's World of Mathematics
passyworldofmathematics.com/online-graph-makersUsing the Kids Zone Create a Graph free online application, here is the resulting Pie Chart. ... (x,y) values table produced, as well as the graph.
How to Create a Graph Using a Spreadsheet: 6 Steps
www.wikihow.com/Create-a-GraphHow to Create a Graph Using a Spreadsheet. To quickly create a graph in a spreadsheet, perform the following steps. Enter your data into the spreadsheet in a table ...
Use Excel to create advanced graphs and PivotCharts TechRepublic
www.techrepublic.com/article/use-excel-to-create-advanced-graphs...13/12/2005 ... I will be using the data from the table shown in Figure A. ... and decided what kind of graph to create, ... Signing-up is free and quick, ...
Tidak ada komentar:
Posting Komentar