Choose the starting point so that the first bin is just below the minimum value of the range and the ending point just beyond the maximum value. Set up the first bin in the first data cell of the column. Use Edit, Fill, Series to create the bins. (In our version of Excel, highlight the column beginning with the bin size and going down far enough to cover the data range and fill down.) Find frequency: For Input Range, click, highlight, and drag the values in the column that has the data you want to bin. The box should read something like this: $K$2:$K$1000 (depending on number of data cells). For Bin Range, do the same except use the bin values. The box should read something like this: $M$2:$M$52 (depending on how many bins you chose). Click on New Worksheet, OK. You should see a new page open up with two columns similar to the table on the right. |
|
Click on the icon for Chart Wizard (looks like bar graph).
Click on the icon for Chart Wizard (looks like bar graph).
Click on a data point.
In Format Data Series, Patterns select the color you want for the dots and reduce the font size to 3.
in Y Error Bars, Display select both.
Choose Custom and highlight the column of error values. Paste into both the + and - boxes.
The box should read something like this:
='Z Mass'!$C$5:$C$80 (depending on number of data cells).