Office 2010                     

 Bar Chart in Excel

Analyze your data and put it into the table on your handout

Input your data into an Excel spreadsheet

Example
In this example the raw data is

-0.1   -0.1   0   0    0    0    0    0.2    0.2   0.2 

Note that the Values go up in even increments and the Frequency has a value, even when it is 0.

You may not need to show as many values as I did.

Highlight (Select) all of the data
Click the Insert tab and the type of chart you want. In our example we are going to do a simple column (bar) chart.  

When you click on the chart you will see three new tabs.

Click the Design tab and the Select Data button.

Click in your data list to select your Range (output or Y values)  Select the column of data that will be the vertical bars in the chart. The computer will automatically fill in the cell references in the box. Do not include the Column Title – in this case the word Frequency. (See image on the below.)

Before you click OK, select the Edit button under the Horizontal (Category Axis Labels.

You will get a new window. Click to outline the X values in the table, excluding the label. The cell references will automatically appear in the the box. Click OK. and OK again.

Entering Title and Labels

Click on the chart to bring up the special chart tabs. Click the Layout tab.

Click the  Chart Title button. I chose Above Chart. Click on the words Chart Title and type in your own title.

Click the Axis Titles button and choose each Axis and type an appropriate title.

If your teacher wants your chart on a separate sheet, click the Design tab and the Move Chart button and choose New Sheet.

You can copy the chart and paste it into a Word document. If it is too wide, change the orientation of your page to Landscape (Page Layout tab, Orientation, Landscape.)

Below is an example of the Chart saved as an Object in Sheet 1