Rutledge                      

 Bar Chart with the Chart Wizard

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 on the Chart Wizard  button on the Toolbar   

Pick the 1^st Column type and click Next.

You will be prompted to select your Data Range. In this case, 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 right)

Before you click next, select the Series tab in this same window.

You will give the cell references for the x-axis labels.
In my example it is cells A2 through A8. Your x values may be in a different column. (See image below)

 

Note: You will need to 1^st click in the box next to the words Category (X) axis labels:

Then on the spreadsheet, click and drag to highlight the X-axis values. In my examples that is the values from A2 through A8.

Click Next.

You will be able to change the Chart Title, Legends, Labels etc. in the next window or you can just click Next.

Choose whether to make chart on a new sheet or on existing page (Object in Sheet 1).

Click Finish.

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 (File, Page Setup, Paper Size tab.)

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