DISCOVER
×

How to create a bar graph from an excel spreadsheet

Updated February 21, 2017

Step 1

Start Microsoft Excel, and open the file you want to use to make a chart.

Step 2

Drag the cursor over the columns you want to show in your chart.

Step 3

Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar.

Step 4

Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left.

Step 5

Press Finish if you do not want to label or format your chart.

Step 6

Press Next to label and format your chart.

Step 1

In the box that appears after you clicked Next, click the Series tab.

Step 2

Click on Series1, and enter a label for your data, such as "Number of Widgets per Month," in the Name field.

Step 3

Click on any additional series, and name those as well.

Step 4

Click Next.

Step 5

Select the Titles tab to label your chart and both its x-axis and y-axis.

Step 6

Select the Axes, Gridlines, or Legend tabs to format the look of your chart.

Step 7

Select the Data Label tab to label specific points on your chart.

Step 8

Select the Data Table tab to add a table of chart data under your chart.

Step 9

Click Next.

Step 10

Decide whether you want your chart on a new worksheet or on the same worksheet with your current Excel entries.

Step 11

Click Finish.

Tips

  • You do not need to select an entire column.
  • A bar graph shows how data has changed over a period of time.
  • A line chart shows trends at intervals.
  • Use the Back button if you want to change your selection.
  • Press Cancel if you do not want to continue creating your chart.
  • After the chart is done, you can also use the Chart menu to change the chart format.
  • Use the Chart Wizard provided with Excel.
  • Use the Back button if you want to change your selection.
  • Press Cancel if you do not want to continue creating your chart.

Things You'll Need

  • Excel Book
  • Microsoft Excel
  • Microsoft Office
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.