How to Make a Bar or Column Chart in Microsoft Excel 2007

How to Make a Bar or Column Chart in Microsoft Excel 2007
Page content

How to Make a Bar or Column Chart

As discussed in Part 1 of this series, the process for creating both bar and column charts in Microsoft Excel 2007 is almost identical. The only difference is that bar charts will display the information “bars” as horizontal objects, and column charts will show them as vertical objects. So, instead of covering identical steps for each chart type, we’ll focus on walking through the steps for making a column chart in this tutorial.

If you’re interested in other chart types, take a look at this collection of Excel chart and graph tutorials.

As an example for creating a column chart, we will take data that has been provided by the U.S. Census Bureau on median rent prices in the United States over the last ten years. We’ve already entered this data, shown in the screenshot below, into an Excel worksheet. (Click the image for a larger view.)

Median Rent Data Table

In this example, we will construct an Excel column chart that shows the median rent for both the entire United States and the western region of the country from 1998 through 2007.

Step 1: Hold down the CTRL key and select the cells that contain the data you would like displayed on the chart. In our example we will select the columns containing information on Countrywide and West median rent.

Select Data for Column Chart

Step 2: Open the Insert tab on the Excel ribbon and click on Column in the Charts section. (Note: If you want to create a bar chart, select Bar instead of Column.) This will expand the list of choices you have for the column chart creation. Here, we will pick the first chart listed in the 2-D column section – Clustered Column.

Choose Clustered Column Chart

If you would prefer to pick another type of column chart type, go ahead. The instructions will remain the same no matter which one you choose.

Step 3: After selecting the chart type, the column chart will appear in the Excel worksheet. You can resize the chart and drag it to a new location on the worksheet if you wish. If you would like to move the chart to a different worksheet, take a look at the directions provided in Moving Charts in Microsoft Excel 2007.

Initial Column Chart

Final Steps

Step 4: Next, we want to modify the horizontal axis of the chart so that the proper column labels are shown rather than just the numbering sequence 1, 2, 3, …, 10. To do this, first right-click anywhere on the chart area and choose Select Data.

Select Data

In the Select Data Source window that appears, click on the Edit button under Horizontal (Category) Axis Labels.

Select Data Source Window

Another window, entitled Axis Labels, will appear on your screen. With this window open, select the labels you want to use for your data on the horizontal axis. Only select the actual label values here – don’t include the column header. In our example, we will select the years 1998-2007.

Axis Labels

Click OK and you’ll be returned to the Select Data Source window. You should see the years listed under Horizontal (Category) Axis Labels now. Click OK again to return to the column chart.

Column Chart with Year Values

Step 5 (Optional): Although this is an optional step, we’ll want to have a title shown on our chart most of the time. To add a title, make sure that the chart is selected and then open the Layout tab under Chart Tools on the Excel ribbon. Click on Chart Title in the Labels section, and select whichever option you prefer for placement of the title. For the column chart in our example, we’ll pick Above Chart.

Chart Title

A new text box will appear on the column chart. You can click on the text box and enter any title you wish.

Edit Title Text Box

Step 6 (Optional): At this point, you have a perfectly functional column chart. However, you may want to take a few extra moments and make some design changes to the chart to make it more visually appealing, or match better with other colors and styles in your worksheet. There are many chart styles to choose from within the Design, Layout, and Format tabs under Chart Tools in the Excel ribbon. Experiment a little and find one you like!

Sample Column Chart

This post is part of the series: Bar and Column Charts in Microsoft Excel 2007

This series includes tips and tricks for working with bar and column charts in Microsoft Excel 2007. We’ll explain what they are, when to use them, and how to create them.

  1. Microsoft Excel 2007: Bar Charts vs. Column Charts
  2. Creating Bar and Column Charts in Excel 2007
  3. Creating Trendlines in Excel 2007