Note that when the graph is selected, your independent and dependent variables are highlighted in purple and blue boxes, respectively. Your final graph should look something like the one above. (In Excel-2007, select Design>Chart Layouts to enter titles and legends). You will not need a legend with only one independent variable. Also make sure to go to the Legend tab and click off the Show Legend option. Click Next when you are done.Įnter your titling. The preview should show a pretty good representation of what your chart will look like. Your Data range should reflect your selection of the independent and dependent data (plus possibly your column headers) in absolute cell references. Click Next when you are done.Ĭonfirm that your Data Series are in Columns in your spreadsheet.

If you want to create a horizontal bar graph, choose the Bar chart type. This chart type creates a vertical bar graph, which Excel refers to as a Column chart. If the Chart Wizard is not visible on the toolbar, you can also choose Insert > Chart.Ĭhoose the Column Chart type and the Chart sub-type in the upper left corner (basic bar graph). With the data shown above highlighted, start the Chart Wizard from the toolbar: (In Excel-2007, choose Insert>Column Chart, selcting the top-lefthand 2-D Clustered Column chart). The headers at the top of each column are not necessary, but they do help identify the variables. Note that the independent variable is placed in the first column while the dependent variable is placed in the second column. Creating a bar graph with one independent variableĭata is entered into Excel much in the same way as it is with scatter plots and line graphs: Histograms are a specialized type of bar graph used to summarize groups of data.

Creating a bar graph with two independent variablesīar graphs are created in much the same way scatter plots and line graphs are.

Creating a bar graph with one independent variable.

Untitled Document Bar Graphs and Histograms in Excel-2003 Table of Contents

Constructing a histogram in excel