How to Make a Bar Graph in Excel 2007

By Sandi Kelly Showalter

When working with spreadsheets, sometimes you may need to convert your data into a graph or chart in order to compare individual items. Excel 2007 provides an easy-to-use function that with the click of a mouse will create a bar graph from your data already in your spreadsheet. With several different bar graph options to choose from, including 2-D, 3-D, cylinder, cone and pyramid, along with an array of colors, you can personalize your graph to the look you want.

Step 1

Start a new document and add data or open the document containing the data you wish to convert into a graph. Arrange the data with the item headers at the top of the column and data in the same column or the headers at the beginning of the row and the data to the right.

Step 2

Select the data you want to include in the graph.

Step 3

Click on the "Insert" tab in the ribbon.

Step 4

Click on the down arrow under the "Bar" graph icon.

Step 5

Choose the graph design you like the best. Your data will convert into a bar graph on the spreadsheet.

Step 6

Click on the "Design" tab to change colors, layout, add a title, switch the rows and columns, move the chart, change the chart type or save as a template.

References & Resources