November 23rd in Charts and Graphs by Excelbud .

Basic Bar Graph in Excel

The following example demonstrates how easy it is to construct a basic bar chart in Excel.

Excelbud

Owner and site operator for Excelbuddy.com

The following tutorial will demonstrate how to construct a basic bar graph in Excel.  The documents for this tutorial are available for download.

  1. To begin, start with a spread sheet as shown below.
    1-basic
  2. Now, highlight cells A3 to B8.  Select the “Insert” tab and hit the “Column Button” to activate the drop down menu.

    2

  3. From this menu, select “2-D Column” and ”Clustered Column.”
    3
  4. The following bar graph will generate.
    4
  5. To add the horizontal and vertical axis labels, select the graph by left clicking anywhere on the chart.  Now, under the “Chart Options” header, select the “Layout” tab.
    5
  6. By utilizing the various buttons, you can customize the graph.
    6
  7. Below is an example of a customized graph.
    7

3 Comments

  • nemop
    January 13, 2010
  • Alprazolam
    July 10, 2010

Leave A Comment.