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