Hi Rob,

It's unclear to me if you have solved your problem or not. Let's assume
not:

1. You can attach the Analysis ToolPak add-in and then use the Tools, Data
Analysis, Histogram tool. (attach the add-in by choosing Tools, Add-in in
XL2003.
2. Or make an XY Scatter chart of your data using the chart wizard. A line
or column chart is not usually the correct choice.
3. The Histogram tool allows you to group the data in increments.
4. If you don't use the histogram tool you can use the FREQUENCY function
or an array formula to group the data.

Cheers,
Shane Devenshire

"Jon Peltier" wrote in message
...
Why is this the wrong group? I assumed you wanted a histogram or similar
representation.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"BRob" wrote in message
...
Oop - sorry.

Posted to wrong group

Rob
"BRob" wrote in message
...
I've got 2 columns of numbers - column A is a continuous set of integers
going from about 40 to 210; column B is a frequency count going from
blank up to 10. A sample is shown below.

PROBLEM 1

Using XL2007 I can't even seem to get a simple bar chart showing
frequency count (y axis) against number (x axis). I just get either a
total as a single bar or a cumulative count.

PROBLEM 2

Once I've got this working I'd like to be able to group those numbers
(eg into 5's or 10's) so as to reduce the length of the x-axis

Can SKS help out please.

Tx




44 2
45
46
47 1
48
49 1
50
51
52 2
53 2
54 5
55