View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
BRob BRob is offline
external usenet poster
 
Posts: 24
Default Creating a Simple Bar Chart - 2 Areas for help please

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