mshaffer -

Here's one way to create the histogram from frequency data:

Arrange data with Grades in a column on the left and Counts in an adjacent
column on the right. Enter labels "Grade" and "Count" in top row. Select any
cell in the Grade or Count column. Choose Insert PivotTable (dropdown) |
PivotChart. Create PivotTable with PivotChart, OK. In the Field List, do
not check the box for Grade; instead, click Grade and drag to the Axis
Fields area (or to the Row Labels area). Then click the box for Count.
Select one of the Grade values (i.e., one of the Row Labels) in the table,
right-click, and choose Group. Specify "nice values" for Start, End, and By
(the step or interval width for the frequency distribution). Optionally,
click one of the bars of the Column chart to select the data series,
right-click, choose Format Data Series | Series Options, change the Gap
Width to No Gap, and Close.

- Mike
http://www.MikeMiddleton.com


"mshaffer" wrote in message
...
I'm trying to use the 2007 histogram tool (or frequency) to show me
the frequency of data, but my data is in a different form than
required for either of these tools. Let me use the following simple
case -- to show the frequency of student grades both tools assume I
have a list of student's test grades. What if I instead have more than
one column, e.g., "grade" and "number students with that grade"??

My application is actually different, but it's still 2 columns, a
numeric property and a weighting factor (e.g., fraction of the total).

TIA :)