How to Create a Graph Using an Electronic Spreadsheet

Table of contents:

How to Create a Graph Using an Electronic Spreadsheet
How to Create a Graph Using an Electronic Spreadsheet
Anonim

This tutorial shows the steps required to quickly create a chart in Microsoft Excel.

Steps

Create a Graph Using a Spreadsheet Step 1
Create a Graph Using a Spreadsheet Step 1

Step 1. Insert the table containing the data to be represented in the worksheet

  • Use the following format:
  • Cell '1-a' will contain the header of the abscissa data (x axis). Time is usually represented on this axis.
  • Cell '1-b' will contain the header of the ordinate data (y axis).
  • The data relating to the x axis will be entered from cell 2-a onwards.
  • The data relating to the y axis will be entered from cell 2-b onwards.
Create a Graph Using a Spreadsheet Step 2
Create a Graph Using a Spreadsheet Step 2

Step 2. Select the cells that contain the data you want to represent in your chart

If you want column and row headings to appear in the chart as well, be sure to select them in the table.

Create a Graph Using a Spreadsheet Step 3
Create a Graph Using a Spreadsheet Step 3

Step 3. Press the 'F11' function key on the keyboard

This will create a new worksheet dedicated solely to displaying a bar chart.

Create a Graph Using a Spreadsheet Step 4
Create a Graph Using a Spreadsheet Step 4

Step 4. Use the graph creation wizard

If the 'F11' function key doesn't work, choose the 'Graph' item from the 'Insert' menu. If you are using the 'Gnumeric' program, the 'F11' key will not work. At this point, all you have to do is choose the chart template with which to represent your data.

  • Select the dataset.
  • Choose your data series.
  • Select the elements of the chart.
Create a Graph Using a Spreadsheet Step 5
Create a Graph Using a Spreadsheet Step 5

Step 5. After creating your chart, you will see the chart toolbar appear

Select the arrow button next to the chart type icon. From the menu that appeared, select the 'Bar Chart' button.

Create a Graph Using a Spreadsheet Step 6
Create a Graph Using a Spreadsheet Step 6

Step 6. You can also create a pie chart if you wish

Advice

  • To add more details to your graph, select the icon to launch the graph creation wizard located on the toolbar, then provide the necessary information.
  • To transform an element of the chart into a title, select the chart area and click on the icon to start the wizard for creating a chart located on the standard toolbar. Select the 'Next' button until you reach step number 3 'Chart options'. In the 'Chart title' field enter the title you want to assign to your chart and press the 'Finish' button.

Recommended:

How to Create a Database from an Excel Spreadsheet

How to Create a Database from an Excel Spreadsheet

This article explains how to create an Access database using a Microsoft Excel sheet as a data source. Access is the database creation and management software included in the Microsoft Office suite of programs. Alternatively, you can export the data from Excel in a format that allows it to be imported into the most famous and popular database engines.

3 Ways to Create a Tree Breakdown Graph

3 Ways to Create a Tree Breakdown Graph

Creating a tree decomposition diagram is an easy way to find all the factors of a number. Once you understand how to create decomposition trees, it becomes easier to perform more complex tasks, such as finding the greatest common divisor or least common multiple.

12 Ways to Cheat During an Exam Using an Electronic Device

12 Ways to Cheat During an Exam Using an Electronic Device

Cheating on an exam is never a good idea. Put yourself and your future at risk. However, if you have to, at least try to get it right. Steps Method 1 of 12: Using the Internet Step 1. While you are taking the exam, consult your mobile phone, netbook or other portable device Using the internet, find answers to questions you don't know.

How to Create a Graph in Microsoft Word: 11 Steps

How to Create a Graph in Microsoft Word: 11 Steps

This article explains how to add a chart in a Microsoft Word document. Steps Method 1 of 2: Insert a Chart into Word Step 1. Open a Microsoft Word document To do this, you can double-click on an existing Word file. Alternatively, open the program, then select the document from the section Recent .

How to Create a Budget on a Spreadsheet

How to Create a Budget on a Spreadsheet

You can use a spreadsheet to compile your budget and better control your expenses. You will be surprised how easy it is to manage your finances with this tool. You can use it as a guide to paying bills, saving money for retirement or major purchases, or simply getting to your next paycheck without incurring debt.