How Do I Transfer Data From a Spreadsheet to a Graph Using Excel?

Written by bryan perkins | 13/05/2017
How Do I Transfer Data From a Spreadsheet to a Graph Using Excel?
One of many charts you can make in Excel. (pie chart 2 image by chrisharvey from

Microsoft Excel makes it easy for you to create a graph from any data. Whether you want to make a bar graph, line graph, scatter plot or pie chart--all you have to do is supply the data and Excel will do the rest. By simply highlighting the data you want graphed and selecting a graph type, you will be on your way to professional-looking charts and graphs in no time.

Open Microsoft Excel from the "Start" menu.

Type the labels for the data you want to graph in row 1 of the spreadsheet. For example, if you are making a graph of the number of different types of vegetables, type "Vegetable" in column A of row 1 and type "Number" in column B of row 1.

Enter the data for each column into the cells under the correct label.

Click and drag from the top left cell to the bottom right cell to highlight all of the cells that contain data, including the heading titles.

Click the "Insert" tab on the top of the screen, then choose the type of graph you want to insert into the spreadsheet. The graph will automatically be inserted into the spreadsheet, and you can now double-click on the title to change it to the title you desire.

Things you need

  • Computer
  • Microsoft Excel

Show MoreHide

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.